Forms

[id1234]

I have my Database with multiple forms and subforms, I am wanting to know if there is a way when I create my accde file if I can force only one form to be accessable to the users and the rest of the forms will only be available based on actions they select during run time.

I have a Login in form that I want the user to have to login in first and after sucessful login it will bring up a switchboard with access to multiple other forms. I do not want the user to be able to pull up the switchboard without logging in nor do I want the user to pull up the other forms without going through the switchboard.

 

[scalextric59]

Check this link,

http://support.microsoft.com/kb/88160

 

[boblarson]

Check this link,

http://support.microsoft.com/kb/88160

Not necessary for that one.

You can go to the Startup Options and set the database window (or Nav pane if on 2007/2010) to not show and then also uncheck the USE ACCESS SPECIAL KEYS checkbox to keep them from having the F11 key to open the db window/nav pane.

Also, you set the form you want opened at first in the Startup Form selection under Tools > Startup (Access 2003) and Round Office Button > Access Options > Current Database (Access 2007) or FILE > Access Options > Current Database (Access 2010).

 

[id1234]

Thank you very much for the response this was exactlly what I was looking for.