password coding

[rachh]

As a new-comer to programming VB in Access, I would like to know how to access the code for the password dialog box. I want to attach code so that when someone enters their password it triggers a welcome message such as Good Morning or Good Afternoon to my database. I have the code to give my message and select whether it is morning or afternoon but don't know how to attach this to entry into a database : myCode = Hour(Now), if myCode < 12 then myMessage = "Good morning."

Any ideas greatly appreciated

 

[David Mack]

How about setting up a form with an unbound text box (which your code would populate)-use the "on activate" or "on load" event of the form. Then, set up your form to be the start up form in your database. Also, in the "on timer" event of the form you could wait for say 2000 ms (two seconds) and then do whatever your db does.


David Mack