0

i need help on making a login page and register page that will be linked together using access. can anyone teach mi the step to make it?

4
Contributors
11
Replies
12
Views
10 Years
Discussion Span
Last Post by hopalongcassidy
0

i'm currently making a rental car project. now i juz need to make a login page which the user can register and access it using access.

0

add another form to your project ex.frmlogin
have two textboxes there one for username one for password
add two comand buttons one for login one for cancel
add adodc to make connection to database
in command login click event search your database for username and check if password matches

0

adodc??? mine is vb 2005... i juz need the step to link them 2gether and the code to make it work only.

0

Add to your components (right click on toolbar)
microsoft ado data control
do you have that?

0

let's call the adodc adologin,the table tbluser

'make connection to database
adologin.connectionstring = 'enter path of where your database is
'Select from your table the name and password entered
adologin.recordsource = "Select * from tbluser where name = '"  & txtname & "'" &  _
"And password = '" & txtpassword & "'"
adologin.refresh
'if no match is found recordset points to end of file
If adologin.recordset.eof = true then
msgbox("wrong entry")
exit sub
end if
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.