Search results

I figured it out on my own... Here's the sql for my update query querydef (qry_update_mytable): UPDATE tbl_MyTable SET tbl_MyTable.F34 = [MyParam] WHERE (((tbl_MyTable.F1) Is Not Null)); Here's the vba code for the module to update the empty field (F34): Dim qdf As QueryDef Set qdf...

How to pass a variable from a module to a querydef? Thanks! I think it'll do the trick!

My database has a number of modules that import data from multiple Excel tables which I receive from multiple people. After using "DoCmd.TransferSpreadsheet" to load the data into the first 33 fields of a staging table (tbl_current_import), I update the 34th field with a value representing the...

How to pass a variable from a module to a querydef? I have a database with several modules that execute sql statements, and I per the information in this thread I wanted to see if I could reduce the bloating of my db by calling a querydef instead. However, I will need to pass the querydef a...

Disabling the close button This worked for me as well! I have a db that logs when users log on and off, but if they closed the application without using the "close" button their log-off time would not be recorded. This solved the problem wonderfully!

Forms/Subforms Take a look at this post it may be something you could modify to fit your purpose. http://www.access-programmers.co.uk/forums/showthread.php?t=89774

Multiple subforms... This may be posted too late to help you this time, as it sounds you already have a solution. However, I created the attached example for a coworker who was having what sounds like a similar problem. The key to what you wanted is...

Thanks for the GREAT advice! I have jumped into vba, and I will probably not use macros much in the future! Now I have to ask myself why didn't I start learning vba sooner??!!

Alternative solution... 1. Open Access, 2. Open your database, 3. Click "Tools", 4. Click "Options", 5. Go to the "View" tab, 6. Locate the "System objects" check box and select it, 7. Click "OK", 8. Go to the Database window, 9. Click "Tables" in the left-hand pane, 10. Locate the...

I am trying transfer data from an Excel spreadsheet using the TransferSpreadsheet action. If the password protected excel file is not open I get an error message "#3161 Could not decrypt file." The excel file has to remain password protected, so I would like to add an error trapping routine to...