Question for ghudson....

Mobjack

Registered User.
Local time
Today, 15:50
Joined
Mar 29, 2006
Messages
15
I did a big search of the forum so I could find info on how to hide the database window and have only the switchboard open. In my search I found your thread with all of the code to make this happen. My problem is that I am new to Access and have no idea where to put the code to make the database window hide. Could you please elaborate on the location where the code is supposed to be placed?

Thanks so much for your help.

Tripp
 
Please include the link to the thread in question. [I have made quite a few postings]. I doubt the info you seek is not included in the thread.
 
You can run the code in any event you want. I run it once when my db is first opened. Lots of programmers have a "splash" or main menu form that opens as soon as the db file is opened. Run it from the OnOpen event of the first form that is opened when your db file is first opened.
 
Thanks a bunch. Will that work on a Switchboard if that is my first screen?

Thanks again.

Tripp
 
I tried ot on the Open even of my switchboard form and it did not work. Any other suggestions? I get the switchboard but the Access window is still behind it.

Thanks!
 
Zipup and post your db and I will look at it.
 
My database seems to be to big to attach. Can I email it to you?

Tripp
 
Mobjack said:
My database seems to be to big to attach. Can I email it to you?

Tripp
Just make a copy of your db, remove anything not related to what you want to test, compact your database, then zip it up and attached it to your next posting in this thread.
 
No wonder it was not working for you... You did not have the code in the db.

I added the code to the OnOpen event of your switchboard form. I also added some code from my Hide all Access Toolbars and Menubars
sample that will hide all of the tool bars and menu bars. Of course I added a button to allow you to easily restore all menu bars and tool bars.

I also removed your AutoExec macro and instead used the db StartUp options to open your switchboard form when the db is first opened.

I suggest that you use the forums search functions and also the Access help files for there is a lot of information out there that will help you learn how to progam in Access.

I have attached my changes.

Good luck!
 

Attachments

Thanks ghudson, I will look at your changes when I get home. I cannot download it from work.
 

Users who are viewing this thread

Back
Top Bottom