Creating Login Page for Access 2003?

Hi,

I created stock control system, i was wondering does anyone know how you can create a login system in it, so only one user can login to the system....Username and password has to be inputted for it to work....

Thanks

 

Im only a beginner any help be great

 

Basically create a form in access



you will need to write put two text boxes and buttons

On click of button match the text box value with username and pass value

If pass and username matches take the user to first form

Otherwise display message login invalid

I have attached a demo form for your reference

Regards

Alex

 

Really appreciate the help

I have managed to get everything up but i am getting an error.

When the user wants to login i want it to go to the main menu but instead i keep getting error of object doesnt support this property or method.

Any ideas its really doing my head in as it the problem i need to resolve to get it fully functional

Thanks all

 

You've most likely used a . where Access expects a !. Try this:

Forms![Formname].[TextboxName]

and see if that helps.