insert a textbox value into access

[jonathandrott]

hi, i'm trying to insert a textbox value into a access database. i get
an error: 'Error: no value given for one or more required parameters.'
nothing is set to be required in the db. is there something wrong
with my syntax?
Dim formConn As OleDb.OleDbConnection = New OleDb.OleDbConnection
Try
formConn.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\CustomerInfo.mdb;"
formConn.Open()
Dim formCommand As New OleDb.OleDbCommand("Insert into
CustomerInformation (FirstName) Values (" & Me.txtFname.Text & ")",
formConn)
formCommand.ExecuteNonQuery()
Catch ex As Exception
MsgBox("Error: " & ex.Message)
Finally
If formConn.State <> ConnectionState.Closed Then
formConn.Close()
End If
End Try

[Rick Wannall]

For starters, you need a single quote before and after the value you get
from me.txtFname.text.

Next, you probably shouldn't be useing me.txtFname.text. That is the value
currently being entered in a text box, before the text box is update. You
probably want .value instead.

Mainly, though, you seem to be trying to insert a new record after
populating only one field, FirstName. Is that really your intention?

[jonathandrott]

no it's not my intention, but before i type every field out i wanted to
make sure it would work. also, when i use single quotes the FirstName
value in the db is & txtFname.value. not what is typed into the
textbox.

[Rick Wannall]

"Insert into CustomerInformation (FirstName) Values ('" & Me.txtFname.Text &
"')"

Single quotes go between the left paren and the double quote, and between
the double quote and the right paren. You want your sql to evaluate to
this:

Insert into CustomerInformation (FirstName) Values ('WhateverITyped')

If you're supplying text, you have to delimit it.

[jonathandrott]

ok, i see. thanks for the clarification. that worked nicely. let me
add the rest of the fields now. thanks a bunch.