Software

Ask something
Discussion Locked

Bypassing Access Startup Shift key

0 helpful
5 replies

by blndo2001

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

In Access if you select a startup form, it will get executed when access starts, you can bypass the form execution by pressing Shift key at startup. Is there any way to bypass the shift key which is used in Access to view the designed forms, queries, tables etc..?

Thanks

5 replies

by richtee

In Tools | Startup? | make sure the box is checked next to ?Display Database Window?.

When you start the database, the database window will load behind the form (or whatever you selected) you selected to display as the default on startup. Diminish the default form and you will have the database view.

If you want database view to display on top, you could add a little code to the default form?s ?On Load? event to have it load diminished

Eg: DoCmd.Minimize

If you only want the Database Window to display, Tools | Startup? | change the display default to ?none?.

Good Luck
Rich

by awilliams3

Two possible suggestions:

Review making an Access MDE file. The option to create one is under TOOLS, DATABASE UTILITIES, MAKE MDE FILES. Be sure to review this option in the help and online help.

Also, if you have access to a Microsoft Office Developer Edition (97+) you have the option of circulating an Access solution as a stand-alone application with an Access run-time.

In either case, I might suggest you split your Access database if you have not done so. By splitting I suggest the data/support tables be separated to a separate MDB from the MDB containing forms, queries, etc.

Good luck!

This discussion is closed to new replies.