General discussion


Automate Access 2000 startup to switchboard

By kaypaul ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by john_wills In reply to Automate Access 2000 star ...

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.

Collapse -

by sgt_shultz In reply to Automate Access 2000 star ...

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

Collapse -

by kaypaul In reply to

Poster rated this answer.

Collapse -

by kaypaul In reply to Automate Access 2000 star ...

This question was closed by the author

Related Discussions

Related Forums