form template for password request

[Guest]

Does anyone have a form template for password requests? Thanks in advance.

 

[Larry Linson]

Does anyone have a form template for
password requests? Thanks in advance.

Fallible though it is, Access' built-in workgroup security is so far better
than any Roll-Your-Own that you aren't likely to find a "form template" for
passwords; the fact that building one is so easy might be another reason:

(1) On the Forms tab of the DB Window, click New
(2) Do not choose a Table or Query (that is, leave the Form unbound)
(3) Add Label(s) with any text you wish to display
(4) Add a TextBox for the user to enter the password, and set its Format
to "password"
(5) Add a Command Button with VBA code to compare the password against
whatever you choose, and
(5a) if it matches, open the first Form of your application with the
DoCmd.OpenForm statement
(5b) if it doesn't match, either allow the user to try again or just
DoCmd.Quit to exit the application

Larry Linson
Microsoft Access MVP

 

[Guest]

I am using Access 2007. I would appreciate very much if you would tell me how
to create the command button. I mean, what is the script to use? If I want to
add a button to a form, I click on the button command and soon after the
Command button wizard starts. I imagine that I should select the Macro
option, and later on write down the macro with the scripts that performs the
comparison and selection and everything else. What would be that macro? Thank
you so much!