Accessing Access (the Sequel)

[shannondbaker]

Ok, I apologize if this link doesn't work:

http://www.mrexcel.com/board2/viewtopic.php?t=82497&highlight=

Basically, what I was trying to find out in the excel portion was if there is a way to have excel's visual basic to open up a access database and specifically control which form or query opens up. Since I wasn't receiving very many hits in the excel side, I figured I would try the access side.

Any help would be greatly appreciated.

Thanks,

Shannon

 

[CT Witter]

You can set access to open a specific form on startup by using the Tools->Startup ->Display Page or Form.

To do a query, I would suggest using the AutoExec Macro...

To do this start a new macro. Add the open query command to the macro. Save the Macro as "AutoExec". Whenever you open the db, the macro executes and the query runs.

HTH,
CT

 

[mdmilner]

Access syntax for opening form is as direct as this.
When you have a few minutes, open up access and create a form then drag a button from the toolbox onto the form. It will initiate the button wizard and allow you to pick from a wide variety of topics. After creating a few, check out the code that's auto-generated for a little self-help.

This is one example of how you can (limited) duplicate the self-teaching effect of recording Excel macros then going back to see what was auto-generated.

DoCmd.OpenForm frmName1

Mike