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

[Bob]

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've tried minimiz but when I minimize the access window, the userform goes away
also.

Thanks for your help,

Bob

 

[Jack Leach]

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'll 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

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[Jack Leach]

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

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[Armen Stein]

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've tried minimiz but when I minimize the access window, the userform goes away
also.

Thanks for your help,

Bob

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