username and password

[lushh]

hi.. i am working on a system and it needs a username and password for security. i am using ms access 2003. and my form looks like this:

the user will enter a username and password in order to get into the system. the system will have 2 or more users. i just wanna ask if anyone has a VBA sample code for this kind of form. your replies wil surely be appreciated. thank you very much.

 

[Teebird]

Login form

I found this somewhere on this forumn - it may help you. All credit to the designer.
Tee

 

[KeithG]

Don't forget to disable the shift key feature if you are using this as a startup form.

 

[lushh]

Don't forget to disable the shift key feature if you are using this as a startup form.

what is a shift key feature? how will i disable it?

 

[lushh]

I found this somewhere on this forumn - it may help you. All credit to the designer.
Tee

hi teebird. thanks for this sample database. it really did help me a lot. i also want to thank the designer for sharing his work. good day! =)

 

[lushh]

I found this somewhere on this forumn - it may help you. All credit to the designer.
Tee

hi teebird. thanks for this sample database. it really did help me a lot. i also want to thank the designer for sharing his work. good day! =)

 

[Teebird]

If you hold the Shift key down as you open the database, it will open in design view - I have the form in the Startup so it loads first and the database (tables etc) remain hidden.

As anyone can access your tables etc by holding the Shift key down on opening, there is a function (available on VBA forumn) that will disable the Shift key. I have not tried it.

See this post:

http://www.access-programmers.co.uk/forums/showthread.php?t=36043