Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recordsets and SQL

Status
Not open for further replies.
rpbenito

rpbenito

Programmer
Jun 13, 2001
63
US
I have done a sql query on a table and have the needed info in a recordset... My problem is now that i have the recordset i want to run an insert sql to put the info in a table....here is what i have

Dim pref As String
pref = rec(1).Value
DoCmd.RunSQL ("insert into ContactInfo(prefix) values( " & pref & " )")


...the error is in the sql statement...i know it is something small...can anyone correct my line of code? thanks a lot
 
Sort by date Sort by votes
In the SQL statement, pref needs to be surrounded by single quotes. Rick Sprague
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Open filtered for and set cursor at particular record
Replies
1
Views
412
Moss100
Moss100
Moss100
  • Locked
  • Question
Find unique rent amount and date this was first charged
Replies
4
Views
566
dhookom
dhookom
Moss100
  • Locked
  • Question
Open New Access Database and Maximise the Application Window
Replies
0
Views
333
Moss100
Moss100
Aurillius
  • Locked
  • Question
Convert Date/Time cell to a date and time in VBA
Replies
2
Views
745
Andrzejek
Andrzejek
AJAY0618
  • Locked
  • Question
How to pass a variable in VBA code by opening a form and storing the variable
Replies
3
Views
218
AJAY0618
AJAY0618

Part and Inventory Search

Sponsor

Back
Top