moody1 said:
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
