Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Access97 – Hidding Database Between Form

Locked

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

Topic

Access97 – Hidding Database Between Form

In reply to Access97 – Hidding Database Between Form

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

Access97 – Hidding Database Between Form

In reply to Access97 – Hidding Database Between Form

Thankyou for you help

Access97 – Hidding Database Between Form

In reply to Access97 – Hidding Database Between Form

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.)

Access97 – Hidding Database Between Form

In reply to Access97 – Hidding Database Between Form

Thankyou for your help

Access97 – Hidding Database Between Form

In reply to Access97 – Hidding Database Between Form

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.

Access97 – Hidding Database Between Form

In reply to Access97 – Hidding Database Between Form

Thankyou for you help and extra info. Muchly appreciated

Access97 – Hidding Database Between Form

In reply to Access97 – Hidding Database Between Form

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

[Author]

Replies