problems with a vba statement, plz help, ty. sam

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

Guest

strMySql = "INSERT INTO AgencyLogTbl (PricelistID, DateWorked, ShiftID)" & _
" SELECT Me!PriceListID AS Expr1, " & _
" Me!DateWorked AS Expr2, 12 As Expr3;"
rs2.Open strMySql, CurrentProject.Connection

something is wrong, can't find it. i am new to ado.

thanks,

sam
 
strMySql = "INSERT INTO AgencyLogTbl (PricelistID, DateWorked, ShiftID)" & _
" SELECT Me!PriceListID AS Expr1, " & _
" Me!DateWorked AS Expr2, 12 As Expr3;"
Try this
"INSERT INTO AgencyLogTbl ( PricelistID, DateWorked, ShiftID) VALUES (" &
Me!PriceListID & ", " & Me!DateWorked & ",12)"

If the values from the form are text, you need to add a single quote before
and after the value
"INSERT INTO AgencyLogTbl ( PricelistID, DateWorked, ShiftID) VALUES ('" &
Me!PriceListID & "', '" & Me!DateWorked & "',12)"
 
thank you thank you, it worked.

i would have never gotten it right. you are truly amazing.

sam
 

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

Help with a select statement 5
trying to create a sample table with 31,000,000 rows 4
Need help with syntax error using ADO RecordSet.Open 2
Problems with an SQL Statement 9
Problems with SQL in vba code 2
you tried to assign the null value to a variable that is not avariant data type - MsAccess 2007 4
problem with simple loop 4
Compile error 1

Back
Top