user only allowed to use the form and can do nothing else outside of the form

[joe789]

Hi Folks,

I am wondering if someone can help me determine someway to setup a microsoft access database that I have so that the user can do nothing at all besides using the input form that I created and that automatically opens and is maximized via the autoexec macro. The reason for this is because although the user does need to use the form to enter or edit data, I do not want the user to close out the form and start playing with the data table or queries outside of the form. Is there a way where if the user closes the form, it will re-open very quickly so that there is no way they can do anything but use the form ... or some method that anyone knows about that might work. I really appreciate any help I can get, because this is for a non-profit governmental agency and this is the final piece that I would like to impliment before roll out into production on Monday.

Thank you,

Joe

 

[KeithG]

First take the sizing capability away from the user and then on the Unload event type Cancel=True. Know every time someone tries to close the form when Access goes to unload the form the close event will be canceled and the form will remail open. The down side to this is it is a pain to get the form into design veiw so I would even suggest making a input box pop prompting for a password to close the form when someone tries to close the form and if they enter the wrong pass word then cancel the close event. Something like I have written below.

Private Sub Form_Unload(Cancel As Integer)

Dim strInput as string


strinput=inputbox("Enter Password to close form")

if strinput<>"Password" then
Cancel=True
end if

End sub


Something like that should get the job done. Feel free to paste into you database.

 

[ghudson]

Use the forms BeforeUpdate event for all data validation.

Check these links out for some working examples that will assist your project.

Hide all Access Toolbars and Menubars

A Better Mouse Trap?

Enable/Disable The Control Box X Button

Check out my posted "changebackgroundcolor.mdb" if you are interested in giving your database windows a custom look by changing the background color of the database window. It is near the end of this thread... http://www.access-programmers.co.uk/forums/showthread.php?t=57846&page=2&pp=20

Searching the forum is a great way to discover and learn the answers to your Access programming questions.