|
-
Aug 14th, 2001, 11:16 AM
#2
In your Project References, set a reference to the Microsoft Access Object Library.
In the declarations section of your form, put:
Private Axs As Access.Application
In a click event somewhere, put:
Set Axs = CreateObject("Access.Application")
Axs.OpenCurrentDatabase (DBPath)
Axs.DoCmd.OpenQuery "Query2"
If you already have the database open, omit line 2.
In line 3, replace "Query2" with the name of the Access Query that you want to run.
Hope this helps.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|