How do I make a form maximize on launch?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I've restricted access to my database via three user levels:

Admin - Full access to edit the db etc
Supervisors - Access to limited forms & reports
Tech - Access to all forms and reports but not able to edit design or
directly access tables.

And i'm trying to achieve the following:

"Admin" access should be as Access would normally launch.
"Supervisors" & "Tech" access should be restricted to the "Main Menu" form
(i.e. no access outside this form and forms launched from it. I'd like this
form maximized on login, with minimize etc disabled.

I would think this is possible, I just can't seem to figure out how to do it!

Any help on this would be greatly appreciated, thanks in advance!
 
Getting there! (I'm fairly new to this if you hadn't guessed!)

DoCmd.Maximize takes care of maximizing the window.

And by making it a pop-up and disabling the buttons (min, max, close) I can
force it to stay maximized.

So all that leaves is....
.... to make the main form open when the database is launched under the db
logins "Supervisor" & "Tech".
.... and to make access close when the main form is closed.

Once again, any help appreciated!
 
I'm as good as there!

Application.Quit
Can be used to quit the application when the close button on the main form
is pressed.
And although I can only seem to make the form maximize at login for ALL
users, this isn't a problem as when using the Admin account I can just
right-click and put it into design view!

Problem sorted!
 
Back
Top