[AccessD] Parameter Queries via Code

Hi Mark

Then I guess the #'s are contained in the query.
If so:

3.        qdfMetrics.Parameters(0) = "'" &
Format(Forms!frmDatePicker!Text14, "m\/d\/yyyy") & "'"
4.        qdfMetrics.Parameters(1) = "'" &
Format(Forms!frmDatePicker!Text16, "m\/d\/yyyy") & "'"

/gustav


>>> dba.email at gmail.com 04/29 7:58 pm >>>
Well now...that was interesting...now I get a very specific message:
"Data type mismatch in criteria expression."

When viewed in the Locals window the first parameter value is
"#10/1/2004#".
Prior to this run, it read "10/1/2004".  In both cases the Type is
listed as Variant/String.

I'm wondering if the problem is the quotes.  For instance, another
property for qdfMetrics is DateCreated.  The value for DateCreated
contains no quotes it reads: #4/28/2005 12:46:53 PM#, and the Type is
listed as Variant/Date.

I tried this:
qdfMetrics.Parameters(0) = DateValue(Forms!frmDatePicker!Text14)
...but the Type was still listed as Variant/String with a value of
"10/1/2004".