help Retrieving data

[sweettama]

hi,
im new joiner and i need help doing my project. im using visual basic and ms access.


how can i retrive the data which i have added in database

i add the data with this code

Private Sub cmd_add_Click()
Dim dbs As DAO.Database
Dim rcd As DAO.Recordset
If Me.txt_username = "" Then
MsgBox "Enter Your Name Please", , "Your Name"
Me.txt_username.SetFocus
Exit Sub
ElseIf Me.txt_password = "" Then
MsgBox "Your Password ", , " Your Password"
Me.txt_password.SetFocus
Exit Sub
Else
Set dbs = OpenDatabase(App.Path & "\Names.mdb")
Set rcd = dbs.OpenRecordset("userandpassword")
With rcd
.AddNew
rcd!UserName = Me.txt_username
rcd!Password = Me.txt_password
.Update
Me.txt_username.Text = ""
Me.txt_password.Text = ""
End With
End If
 
 
End Sub
 
 

im hoping you can help me with this

regards,

[debasisdas]

are you trying to create new id in database and login with existing ids ?

[rpicilli]

Hi there.

I could realize that you create a data entry for your data base with 2 or 3 fields.

UserName
Password amd probably an Id for each register line of your database.

To perform what I think you want you need to create a Query with Parameters.

Something like "SELECT UserName, Password FROM YourDataBaseName
WHERE UserName = txtName.text AND
Password = txtPassword.text

This Query will return to your program a Row of your database if is there one that has the information you supply in your Query.


I hope this could help you

Rpicilli

[sweettama]

Thank you for your help :)