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


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
 
Ad

Advertisements

J

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

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

Advertisements

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top