PASSWORD on command button

  • Thread starter Thread starter H
  • Start date Start date

H

Registered User.
Local time
Today, 20:13
Joined
Sep 3, 2001
Messages
11
i only found this page today and it has really helped, got a problem, is it possiable to put passwords on command button, so only select few have access to that form, if so it would really help. Thanks
 
I will have to assume that an "unauthorized" person has no other means to get to the form within the database. (i.e. in database view)

The password can work on the command button, but writing the code to the OnClick to throw up a password form and then check it against the "password" using If-Then code statements. If it matches, open the form, else if - MsgBox "Wrong Password". Go back to other form.
 
If all users have 'accounts' then you could test to see what person or group is loggged on and allow or deny access that way!

e.g.
if currentuser() = "Admin" then exit sub
if currentuser() = "H" then
docmd.openform "myform"
end if
 
THANKS FOR THE ADVICE I FOUND THAT SOMEONE AT AN EARLIER STAGE ASKED THE SAME QUESTION AND I USED THAT INFORMATION AND IT WORKS, MY BOSS IS WELL IMPRESSED THANKS
 
can u send/ show us the code for password on command button

Hi ,

i just wanted to know where was the path or the code for the password on te command button. i just wanted to see if it varies from what i have written.:)
 
thanq it got resolved

Thanq i got the answe for the site u mentioned. It was of great help:) :p ;)
 

Users who are viewing this thread

Back
Top Bottom