Maximize Screen

P

Paul

hi, the database is built and it looks ok but the docmd.maximize still left
the access bar at the top even though ive disable all of the items in start
up.

The problem was resolved by setting Popup and modal to Yes. but ive got
quite a few forms and it will take time to set the properties of each one.

Is there a way that this can be done for all forms in the database as ive
got several and woudl rather do it with code in one go that go back through
all of the forms?

regards,

Paul
 
R

Robert Morley

Which "Access bar at the top" do you mean? The menu bar (e.g., "File, Edit,
View")? The title bar (e.g., "Microsoft Access - My App Name")? The
toolbar (i.e., the one with all the pretty icons)? Nearly all of them can
be disabled, or at least customized, if nothing else, so maybe it's better
to look at doing that, rather than setting all your forms to modal popups.



Rob
 
P

paul

thanks rob, its the menu bar (file, edit, view ect) ive disabled the rest.
but the only way ive found to get rid of the menu bar is to set the
properties of modal and popup....
 
R

Robert Morley

Well, in "Tools", "Startup Options", you can at least limit what the user
gets on the menu bar.

I'm a little rusty, but I *think* you can also get rid of the menu bar
entirely with the Application.CommandBars collection. (I think that's where
it is, anyway...not only am I rusty, but I'm not at work right now, so I
can't check for you readily.) Have a look at that, and if you don't figure
anything out, I'll have a go at it tomorrow when I've got my laptop handy.



Rob
 
R

Robert Morley

As promised, I had a look at this today. The command you're looking for is:

Access.CommandBars("Menu Bar").Enabled = False 'to hide it
' or
Access.CommandBars("Menu Bar").Enabled = True 'to show it



Best of luck,
Rob
 
Top