login page and register using vb 2005 and access

[arlowha]

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?

[debasisdas]

Kindly post what you have done so far. Post where you are struck.

[arlowha]

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.

[arlowha]

anyone can teach mi?

[plusplus]

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

[arlowha]

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

[plusplus]

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

[arlowha]

izzit the ADODC?

[plusplus]

yes, do you know how to use it?

[arlowha]

sry i don noe.. teach mi plz ty

[plusplus]

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

[hopalongcassidy]

You can find a tutorial on ADO (ActiveX Data Objects) on www.w3schools.com.