Message box asking for password Frank Situmorang 12/23/2008 11:00:00 AM Hello, I have a switchboard that I modified from the built in Ms Access sample database. My question how can I have a message box requesting for pasword, then I go to open a form in which we have the Option to open again many forms. Thanks for any idea provided. -- H. Frank Situmorang

RE: Message box asking for password Daniel Pineault 12/23/2008 12:40:08 PM I'm not sure if I understand 100%, but if you want to control access to your database then you should ook into ULS which stands for User-Level Security. With ULS you can create accounts and control who has access to what. If on the other hand you just want to password protect a single for then take a look at http://support.microsoft.com/default.aspx/kb/209871/en-us -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "Frank Situmorang" wrote: [Quoted Text] > Hello, > > I have a switchboard that I modified from the built in Ms Access sample > database. My question how can I have a message box requesting for pasword, > then I go to open a form in which we have the Option to open again many forms. > > Thanks for any idea provided. > -- > H. Frank Situmorang

Re: Message box asking for password "tkelley via AccessMonster.com" <u47368[ at ]uwe> 12/23/2008 5:31:32 PM I agree with Daniel that you may want to move toward a more robust method. However, if you indeed want to continue doing what you are doing, then look into the InputBox function in help. Frank Situmorang wrote: [Quoted Text] >Hello, > >I have a switchboard that I modified from the built in Ms Access sample >database. My question how can I have a message box requesting for pasword, >then I go to open a form in which we have the Option to open again many forms. > >Thanks for any idea provided. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1