Passing values into a doCmd.RunSQL statetment

M

Mike

Hi,

After assigning a value to a variable - for example

x = 12/12/2005

I am trying to pass this value into the where clause of the following

doCmd.RunSQL("UPDATE tblDates SET ColumnY = 1 WHERE ColumnZ = X")

The problem is what is the syntax to correctly pass the value into the
statement

any help/suggestions would be appreciated
 
A

Alex Dybenko

Date values you should put in #
string values in quotes

so in your case it should be:

doCmd.RunSQL("UPDATE tblDates SET ColumnY = 1 WHERE ColumnZ = #" & x & "#")
 
B

Bas Cost Budde

Alex said:
Date values you should put in #
string values in quotes

so in your case it should be:

doCmd.RunSQL("UPDATE tblDates SET ColumnY = 1 WHERE ColumnZ = #" & x & "#")
Click to expand...
Be sure to format the date in US order: mm/dd/yyyy
 

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

Selecting values from a table and using them in vba code 2
Passing values into DoCmd.RunSQL 1
Button on Form Appends Current Record to Another Table 3
Passing Variable Values from Current db to External Database 3
Using variables with RunSQL method 1
Use a Query's Result inside an UPDATE Statement (VBA) 2
SQL date and milliseconds 7
Syntax for UPDATE sql statement 3

Top