INSERT INTO Statement

M

MCyn

I have a INSERT INTO Statement in a program of mine. I first have a INPUTBOX
asking for the users Name, than asking for a password. Now if that password
is incorrect, I have an ELSE statement making a SQL with the INSERT INTO
statement. The user's name they inputed is stored in a variable and my code
for the INSERT INTO is as follows: "INSERT INTO table(field) VALUES(???)" Now
my question is: where the (????) question marks are, how would I input the
variable that has the users inputed name. I tried placing the variable name,
but keep getting a box that opens up that asks for "Parameter Value". Any
help would be appreciated.
 
T

ti976

"INSERT INTO table(field) VALUES('" & varName & "')"
Note the single quote: I'm assuming this is a text field
 
Top