I have database as follows

table name :users
Fields: name,uid,pwd,confirmpwd

I have designed a form in VB 6 to signup if he is new user and he has entered the data and clicked on submit button it should check from the database whether it exists or not. I want the logic for this problem specified in visual basic 6 and database is access.it should check the fields should not be null if null again has to reenter the details and then only the userid and pwd should be created.

Please give me the solution for this problem.

Well first thing you should do is create a table on access....

Code to the VB6..then code an connection to your database ..hmmm

ODBC connection....then you could post your progress here...

Private Sub cmdsubmit_Click()
Dim s As String
RS.Close
RS.Open "select * from users", CN
s = RS(1)
RS.AddNew

Do While (txtname.Text <> "" And txtuid.Text <> "" And txtpwd.Text <> "" And txtconfirmpwd.Text <> "")
If (txtname.Text = "" Or txtuid.Text = "") Or (txtpwd.Text = "" Or txtconfirmpwd.Text = "") Then
txtname.SetFocus
End If
RS(0) = txtname.Text
If s = txtuid.Text Then MsgBox "User Id already exists", vbCritical + vbInformation, "User Exists"
txtuid.SetFocus
If s <> txtuid.Text Then
RS(1) = txtuid.Text
RS(2) = txtpwd.Text
ElseIf RS(2) = txtconfirmpwd.Text Then RS(3) = txtconfirmpwd.Text
Else
MsgBox "Confirm Password must be same ", vbCritical + vbInformation, "Wrong Password"
txtconfirmpwd.SetFocus
End If
RS.Update
MsgBox "User Id and Password Created "
Loop
MsgBox "Enter Data", vbInformation
txtname.SetFocus

this way i have given the code

I found something for you...take a look on it

http://www.dreamincode.net/forums/showtopic11308.htm

Try to used the search buttons...

This post has been edited by eXceed69: 22 Nov, 2006 - 10:54 PM