Recent content by RobCPA

Try this: Shell("msaccess c:\accessdb.mdb /xRunMac") This worked for me based on a test I did on my computer. You may need to add the full path for msaccess. Also, This will open an instance of Access in order to run the macro, so you'll probably want to add a Quit command to the macro to...

Rather than trying to calling the OnOpen method, I would suggest moving the common code to a separate function, then simply call that code when either opening the form or on the click event of the Reset Command Button.

Take a look at faq705-2882. It fixes the problem the majority of the time.

The database file may be too large. Access has a restriction of 2 GB for a database, and if any process causes the file to exceed that limit, you'll get the "invalid argument" error. You'll either need to export the objects to a brand new database or try compacting the file. This has...

Have you tried faq705-2882?

That fixed it - thank you!

I have a form that has a close button. If the record has been modified and the record has not saved (the record is 'dirty'), then a message box appears asking the user if the record should be saved. My problem is that even if the user selects no and the cancel event happens, the routine...

Sheco, That worked - thank you! Rob

I've created a dll that contains a class module with Property Lets and Gets. I'm passing in the server and database string variables, but need to get these passed to standard modules within the dll so that I can open ADO connections for use in other standard modules. Can someone explain how to...

Here are a couple of ideas. First, I got the same error when trying to export a spreadsheet where one already exists. For example, I exported to c:\test.xls which already existed and was also read only. I didn't get the error if the file existed but was not read-only or if the file did not...

Try recalculating the form using the following code: me.recalc

Here's a link to an article by Ken Getz on the Microsoft website. I used this when I was starting out in class modules. http://www.microsoft.com/OfficeDev/Articles/classmod.htm

If you open the query in design mode, choose the menu item of View -> Properties, you should see a box that has the title of Query Properties. The third property is 'Column Headings'. You can fill this in manually to force a column heading even if it doesn't have any data. This can also be...

You must set a reference to the "Microsoft Scripting Runtime" in order for the FileSystemObject to work. Rob

Can you link to the AS400 table via ODBC? If so, you could simply write an append query to select data form the AS400 table into your Access table. That's what I do with tables that are in HP3000 (Amisys).