DataBase - Hide Access Window, Database Window, etc Showing only User Forms?????

Asked By Bob

05-Dec-09 06:47 PM

Hello,

I have just written a small app in Access 2003 in VBA.  When the application starts it show the access windos, database window, then the UserForm
window appears.  How do I hide all windows except the userform????  I have tried minimiz but when I minimize the access window, the userform goes away
also.

Thanks for your help,

Bob

05-Dec-09 07:38 PM

In versions earlier than 2007, Startup Options can be found under the Tools
menu.  Here you can specify if you want the database window to show or not.

Create an .mde (Tools, Database Utilities, Create MDE in versions < 2007) to
remove any design functionality from the application.

Hiding the access window itself is a bit trickier.  I will post a link here to
a module at mvps.org that will do this for you, but be warned... you must
have superb error handling.  This is a very difficult task to pull off
without unwanted side effects.  In many cases this requires a restructure of
the all the code in your application.

http://www.mvps.org/access/api/api0019.htm


hth
--
Jack Leach
www.tristatemachine.com

-Thomas Edison (1847-1931)

05-Dec-09 07:40 PM

This is not to say that 2007 does not have these options, but I have never
used the program, and hence am not sure where to find them...

--
Jack Leach
www.tristatemachine.com

-Thomas Edison (1847-1931)

05-Dec-09 10:35 PM

Hi Bob,

Look in Tools | Startup Options.  You can control those things and
more.  Hold down the Shift key when launching your database to skip
the Startup Options and open it as a developer.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com