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

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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)
 
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)
 
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
Click to expand...

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
 
Back
Top