Browse by Tags

How do I call a function and cancel an update according to the result?

Hi! I recently got this working code from another question, but I need some help finishing it. I have 21 fields where users can fill in their membernumbers to book schedules. When they enter a number, the number is checked against all the other fields on all the date-records to check if the member already...

Posted to Access Coding/Macros (Forum) by microsoft on 05-17-2010
Import text file into Ms Access and replace missing values with value form previous record

Hi, I have a requirement to import data (txt file) into an access db. The text file is from our corporate HR system. The issue is that the file drops certain values from the text file output where the value is repeated, exactly like ms access function 'Hide Duplicates'. The issue is that I use...

Posted to Access Coding/Macros (Forum) by microsoft on 05-08-2010
Runtime error '2147467261 (80004003)': Automation error invalid pointer

Hello Experts: I have an AutoExec function called ChangePrinter that captures what the current default printer is (global) and then sets it to a specific printer. On the Switchboard form, in the on close event, it calls GoDefaultPrinter to change it back to the original printer that Windows was set to...

Posted to Access (Forum) by microsoft on 03-19-2010
How Do I Check a Multi-Word String and Build a SQL Query in VBA

Hi Experts! I need some help from a VBA string guru. My Access database has a form that allows the user to type search criteria for various fields and run a report against their search criteria. When they click the Print Report button, VBA code builds a query by looping through the form controls and...

Posted to Access Coding/Macros (Forum) by microsoft on 03-04-2010
Can I use DoCmd.CopyObject to copy a form with VBA code from one database to another?

I'm using Access 2007, creating Access 2002-2003 databases (.mdb) I am trying to create a small database to be used as sort of a "Service Pack" for an existing database. It has some forms that have been modified since the existing database was deployed, and it's only job is to export...

Posted to Access Coding/Macros (Forum) by microsoft on 02-08-2010
VBA INSERT Statement - Get MAX(Date/Time)

I need help with code sample to get the max(system_creation_date) where the acct_nbr in Tbale 1 = the acc_nbr in table 2. That data needs to be inserted into another table. Asingle row should only be returned per acct_nbr match. Table 1 has 65,000 records so I need to loop through until complete. I am...

Posted to Access (Forum) by microsoft on 01-21-2010
Converting Dates with SQL

Howdy, I am modifying an Access 2003 table. The original table has a, "Date/Time" field which has dates in the formats: 9/23/2008 and 11/24/2009, etc. These dates represent credit card expirations. Using SQL, I would like to copy these dates into a new table and field while converting them...

Posted to Access Coding/Macros (Forum) by microsoft on 01-12-2010
Telling Access to print a report in two copies?

Hello, Is there a way to tell Access to print a report in two copies? It would be neat to immediately have two copies of the reports instead of having to manually xerox the first (and only) report. Thanks a lot! Jerome

Posted to Access Reports (Forum) by microsoft on 11-09-2009
How can I get access to group / index records with certain criteria?

***Newbie Access developer seeks expert looking for a bit of a challenge (& some points)*** I am building an MS Access system that manages days of meetings that users are booking on behalf of their clients. I have a main form that contains a continuous subform (see attached image) that displays the...

Posted to Access (Forum) by microsoft on 10-31-2009
Need help calling a stored procedure on a SQL server with Access 2003

I need to execute a stored process on a sql server from access 2003 but also need to move data from that access database to the server with the same stored process....I need some help with the coding. Basically I am taking a list of daily operations and need to post them on a SQL table called "dbo...

Posted to Access Coding/Macros (Forum) by microsoft on 09-16-2009

Page 1 of 2 (14 items) 1 2 Next >