Community archive

Ask something
Discussion Locked

Automate Access 2000 startup to switchboard

0 helpful
4 replies

by paulkayengheng

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How can I start Access 2000 to open a database with switchboard menu option directly?

What are the steps to do it? Do I need to use macro?

4 replies

by john_wills

While in database window, Tools/Startup; a window will appear with various possiblities including Display Form; this window has a drop-down list of all the forms in your database, and you can choose one. In your start-up form it is probably appropriate to have an On Open event with DoCmd.Maximize, so that when the user clicks the icon she at once sees your opening form filling her screen.

by sgt_shultz

if your question is how to get the switchboard to open when the access file opens, in that access file, make a macro that opens the switchboard form. name the macro 'autoexec' and it will run and open the switchboard when the access file first opens.
if you are asking how to get a database to open when you click a button on the switchboard, you first need to create the query, form, raw table, or whatever you want presented when the button is clicked. probably a form which opens in edit view or new record view...? then you make a macro that opens that. name it something descriptive. then attach it to the on-click event on the button properties. see access help for better explanation. have fun hope this helps

This discussion is closed to new replies.