Search results for query: *

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).

We have developed a merge purge application where we attempt to match one incoming name and address to records in another table (4 million records). The address matches consists of 10 different checks with different point levels for each type of match. Currently, we have stored procedures that...

ralphtrent: I was thinking about the ODBC, but until you posted I didn't realize that you can create a system DSN pointing to a web address. I haven't been able to test this yet, but I think that your suggestion will work. Paul: Your post is a good overview. It's a bit of a learning curve...

I've been programming in VBA and SQL for a few years, but am new to ASP and web programming concepts. I'm creating my first ASP page with an Access table as the database. I can figure out how to get data from the database to the web page and also to save data from the web page to the database...

Thank you for your response. My question does not relate to Access security at all. If you take a look at the left hand side of the Access screen, there is an Objects box and within that you can select Tables, Queries, Forms, Reports, Pages, Macros and Modules. Directly under that section is...

In Access 2000 and XP give the user the capability to create Groups which can contain links to particular objects such as tables, queries, etc. Does anyone know if there is a way to copy these objects to groups programmatically using VBA?