General discussion

Locked

Access97 - Hidding Database Between Form

By paull ·
I am using macros to navigate between forms.
Is there a way to have a blank "screen" which can be used to hide the database design?

At the moment, when I change to another form the database is viwable until the next form is loaded.

Thanks
Shane Paull

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access97 - Hidding Database Between Form

by MelodyJ In reply to Access97 - Hidding Databa ...

I don't know of a way to hide the database only when switching between forms. Maybe the best option for you would be change your startup options to hide the database window(Tools,Startup - Uncheck "Display Database Window").

Regards,
Melody

Collapse -

Access97 - Hidding Database Between Form

by paull In reply to Access97 - Hidding Databa ...

Thankyou for you help

Collapse -

Access97 - Hidding Database Between Form

by pawzer In reply to Access97 - Hidding Databa ...

If your macros move you directly from one form to another, you can leave your database hidden all the time by going to Window, Hide. That will allow you to view anything that is seen on your Switchboard, but not the underlying tables, queries, etc. (This is assuming that you are starting from a Switchboard form to move between other forms.)

Collapse -

Access97 - Hidding Database Between Form

by paull In reply to Access97 - Hidding Databa ...

Thankyou for your help

Collapse -

Access97 - Hidding Database Between Form

by Bob Sellman In reply to Access97 - Hidding Databa ...

Hide the database window by going to Tools, Startup, and uncheck Display Database Window. You can also hide toolbars, menus, and ability to change toolbars and menus at this same dialog box, if you want. This is also the place where you can, by filling in Application Title, designate what you want displayed on the toolbar when the application is open (example: MyApp 1.0).

If you don't current have a main form with buttons to call each macro, make one and add a macro (if you don't already have one) named "AutoExec" that opens the main form. (The AutoExec macro automatically executes unless you hold the Shift key down while clicking to open the database.)

Good luck.

Collapse -

Access97 - Hidding Database Between Form

by paull In reply to Access97 - Hidding Databa ...

Thankyou for you help and extra info. Muchly appreciated

Collapse -

Access97 - Hidding Database Between Form

by halleyc In reply to Access97 - Hidding Databa ...

You can run your access application in run-time mode.

For example, start your application "c:\Program files\microsoft office\office\msaccess.exe /runtime c:\mydb\myaccessfile.mdb"

You can check complete startup parameters from access help.All design mode is disabled if you run Access in runtime mode

Back to Web Development Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums