Shoutbox

lol yet again i have more problems on VB.

Problem 1:

I have added a create user option on my system. i have added a Passkey option so that only people who know the passkey (users of the system) will be able to make an account. I have set it all up, but if i dont type the passkey in the get a "Run-time 13, Mismatch" error but when i do type the passkey correctly it will work fine. I want to get rid of that error
(see the form, "frmNewUser" in the attached file for the code)
SOLVED

Problem 2:

I want to add information i type in on a form in Vb to save in the access database

Note: try not to write me an essay lol. (that means you Cookie ) i have looked around the web, no such luck.

I will update this post with the project

1) it cant set itself as nothing so just be lazy

code:

---

Private Sub cmdOK_Click()
    Dim Username As String
    Dim Password As String
    Dim Email As String

If txtPasskey.Text = "12345" Then
    Username = txtUsername.Text
    Password = txtPassword.Text
    Email = txtEmail.Text
    Open Filename For Append As #1
    Print #1, Username & "|" & Password
    Print #1, Email
    Close #1
    txtUsername.Text = ""
    txtPassword.Text = ""
    txtUsername.SetFocus
    MsgBox "User account created"
    Unload Me
Else
    MsgBox "Passkey is invalid"
End If
End Sub

---

2)
when you go to open the data base. we dont have the same folders as you do, so it would be alot better to add something like:

code:

---

  db.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=" & App.Path & "\Stock Control 97 Version.mdb;"

---

and im sorry, but i havnt been able to answer any of the database questions. i dont understand why either

part 2 needs more help and ill attach the new project. thanks for part one tho

[Edit] I changed the the code for problem one so its now solved, and changed the path to the database for problem 2
i have attached the UPDATED forms, database, etc.

also if you want to login to the program, use this login info:

Username: test
Password: test

bump. i need to get this sorted as its my school project

basically what ive done is scrap the access part and replaced it with another but its done without using the wizard. i.e i set text boxes to get the info from the access form.
but say if i wanted to create a form on VB, it has the same fields and the access form and i typed in new info, how would i go about saving it in the access database instead of another stand alone file?

sorry if its a bit unclear