[Suigetsu]

I want to make a simple Menu, Registration and log-in form. If i click register the registration form will pop out, if i click log-in the log-in form will pop out and if i click cancel it will close.
Problem:The code works but every time i input a username and password it doesn't add up to my database which i created from MS Access. I tried using the code for registration and it works just fine but if i put 2 more forms it doesn't add up to my database.
Thanks

Code for Menu form:

Private Sub Button1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)
Handles Button1.Click

Dim x as Form1 = New Form1
x.Hide()
me.Show()

End Sub
End Class

Private Sub Button1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)
Handles Button2.Click

Dim y as Form2 = New Form2
y.Hide()
me.Show()

End Sub
End Class

Private Sub Button2_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)
Handles Button2.Click

Dispose()

End Sub
End Class

Code for registration:

Private Sub Form2_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)
Handles MyBase.Load

End Sub

Private Sub Button1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)
Handles Button1.Click
Try
cn = New OleDbConnection("Provider=Microsoft.Jet >OLEDB.4.0;Data Source=D:\megaera\data.mdb;")
cn.Open()
str = "insert into table1 values("&Textbox1.Text&",'"&Textbox1.Text&"')"
cmd = New OleDbCommand(str,cn)
MessageBox.Show("Registration Success!!")

Catch
End Try
cn.Close()
End Sub
End Class

I'm still searching for a code for the log-in form.

[polens]

for your login you will query for the username and password..
"SELECT * FROM tblUserAccounts WHERE username='"& txtUserName.text &"' AND Password='"& txtUserName.text &"' "
You may convert this to parameters...

to check if there is a "HIT"

Put it in a dataAdapter
"oledbdataadapter.fill(datatable)"

then
'if their are hits
if dt.rows.count > 0 then
successfully login
else
incorrect
end if

[CharlieMay]

It doesn't add to your database because you're not executing the command

Add this right before your msgbox("Registration Success!!") line

cmd.ExecuteNonQuery()