Validate username and password in a Button

[puuts]

Hello Gurus,

I'm new in access and I would like to ask how can i validate the username and password in a textbox? I have a frmLogin and frmMain.

I have also a table called 'tblUsers' with column fields 'username and password'.

If username is not found in database then a msgbox will prompt 'Username is not yet created'.

If username is okay and password is incorrect then msgbox will prompt 'Incorrect password'

If username and password is okay, then a msgbox will prompt 'Successfully login' and will continue to frmMain.

Thanks in advance Gurus!

 

[jdraw]

You have the logic you want to use, what exactly is the problem?

 

[puuts]

Hello jdraw,

Thanks for the reply, my problem is the coding of the logic as I'm new to database

 

[jdraw]

I'm going to suggest 2 links that I suggest you read and keep for reference. Unfortunately they don't specifically address your question.

Principles

ERDiagramming

And more related to your question

Learn VBA by Crystal

FunctionX VBA

Good luck.