If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Password Protect form
I have a command button on a from that opens up a second
form. Is there any way that i could add password protection to this button to stop others opening up this form. Any help would be much appreciated Cheers |
#2
|
|||
|
|||
Password Protect form
A simple code based solution would be to prompt the user to enter the
password using an input box and then compare what they enter to a hard coded password in code. Of they match open the form. If not electrocute them, I mean don't open the form. You could event use a small custom form instead of an input box, then you could use the Password input mask to show just asterisks so others don't get the password by looking over someone else's shoulder. If the right password is entered you could than pass that to the opening form as an open argument and add additional checks OnOpen to make sure it is the correct password. That would prevent someone opening the form directly from the database window. Of course is users have access to the code and know what they are doing they could get around it, but if you are using only to "encourage" people to not open the form it will work fine. Also if you are running in runtime mode they won't be able to get to the code. You could convert the database to an MDE to prevent access to code, but that is only recommended if you maintain a separate copy for further development work as MDEs cannot be modified Tony Vrolyk wrote in message ... I have a command button on a from that opens up a second form. Is there any way that i could add password protection to this button to stop others opening up this form. Any help would be much appreciated Cheers |
#3
|
|||
|
|||
Password Protect form
You could implement User-Level security and then not grant certain users
access to the 'protected' form. Why reinvent the wheel by coming up with complicated password scemes and coding events? Just use the built in security. An added advantage is taht you sign in one time when you open the database and your security permissions are set. No need to constantly type in passwords everytime you try to open a form or run a report. Rick B wrote in message ... I have a command button on a from that opens up a second form. Is there any way that i could add password protection to this button to stop others opening up this form. Any help would be much appreciated Cheers |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Password Protect the Unhide Sheet Function | Paul B | Worksheet Functions | 0 | June 11th, 2004 08:15 PM |
Protect Form Button | McDaniel | General Discussion | 2 | May 21st, 2004 08:37 PM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |
Changing dsn connection information (Password) | Mike N | Worksheet Functions | 2 | December 3rd, 2003 08:04 PM |
Password protect & read only | ANGELA | Worksheet Functions | 1 | November 7th, 2003 03:49 PM |