Creating User Login Screen

[Micromax]

Thanks for the link rodmc. I have something similar, but that code covers more i.e number of tries to login and also msgbox(es) for uesr name and failure to login after 3 attempts. Very good, but the only thing missing or I missed is how do you hide the db objects at Startup on Access 2003. I believe I received an answer to this from Michael,bu that was Access 2007.

Thanks for the link rodmc.

Rob

 

[pbaldy]

In 2003 I believe it's in Tools/Startup.

 

[Micromax]

Hi Paul,

I know where the Startup page is in 2003,but it the key is to hide the db objects at startup. That is what I'm trying to do or know how.

Thanks

Rob

 

[pbaldy]

Yes, uncheck "Display Database Window".

 

[Micromax]

Paul,
I didn't even know about that. Thank you,thank you thank you. The code should work now.

I noticed that I had to remove code that minimized the database objects on th On Open Event. I removed it.

It works.

Thanks Paul,

Rob

 

[pbaldy]

No problem Rob.