INSERT INTO Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
"INSERT INTO table(field) VALUES('" & varName & "')"
Note the single quote: I'm assuming this is a text field
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Example Of VBA SQL Statement 0
VBA - retrieve data on last create named range from previous inserted named range 0
INSERT Multiple strings in Table 1
SQL Server and Access 2007 1
Design advice SQL or QueryDef 2
Insert empty numeric value 3
Wifi Network Issue 0
MS ACCESS Insert statement problem using Visual Basic 2010 0

Back
Top