SQL Too Few Parameters

[DS]

I have this SQL code that isn't working, it says too few parameters -1
I'm only putting one field into the tale Customers, the field is PName.
The value from an unbound textbox. If I go to the table and type a new
Pname in it works fine. Is this a Syntax problem?

CurrentDb.Execute "INSERT Into Customers(PName) VALUES(" & Me.Text1 & ")"

Thanks
DS

 

[Rick Brandt]

I have this SQL code that isn't working, it says too few parameters -1
I'm only putting one field into the tale Customers, the field is
PName. The value from an unbound textbox. If I go to the table and
type a new Pname in it works fine. Is this a Syntax problem?

CurrentDb.Execute "INSERT Into Customers(PName) VALUES(" & Me.Text1 &
")"

Thanks
DS

Are you sure Me.Text1 doesn't contain a Null value? If it did then the
string would evaluate to...

INSERT Into Customers(PName) VALUES()

 

[Douglas J Steele]

Presumably PName is a text field. That means the value you're writing to it
must have quotes around it:

CurrentDb.Execute "INSERT Into Customers(PName) VALUES(" & Chr$(34) &
Me.Text1 & Chr$(34) & ")"

(Chr$(34) is the equivalent of ".)

 

[DS]

Presumably PName is a text field. That means the value you're writing to it
must have quotes around it:

CurrentDb.Execute "INSERT Into Customers(PName) VALUES(" & Chr$(34) &
Me.Text1 & Chr$(34) & ")"

(Chr$(34) is the equivalent of ".)

Thanks, Got it to work!
DS