[AccessD] Parameter Queries via Code

You know...this happened to me once before...going 'round and 'round
on a problem till it was pointed out that what I was attempting
couldn't be done with a totals query.  As it happens, this IS a totals
query...could that be the problem?

Mark Mitsules


On 4/29/05, Gustav Brock <Gustav at cactus.dk> wrote:
> Hi Mark
> 
> If none of these work, your SQL must be pretty strange.
> 
> You may have to bring it forward ...
> 
> /gustav
> 
> >>> dba.email at gmail.com 04/29 9:04 pm >>>
> These each produce data type mismatch errors.
> qdfMetrics.Parameters(0) = 1., 2., or 3.
> 
> 1. Forms!frmDatePicker!Text14
> 2. "#" & Format(Forms!frmDatePicker!Text14, "m\/d\/yyyy") & "#"
> 3. DateValue(Forms!frmDatePicker!Text14)
> 
> In an online example that I saw, they used the following:
> Dim prm As Parameter
> For Each prm In qd.Parameters
> prm.Value = Eval(prm.Name)
> Next prm
> 
> This method hasn't worked either...same error message.
> 
> I can't remember exactly how the quote goes...something like "I must
> be closer to the solution, because I've just discovered another way it
> won't work".
> 
> Mark Mitsules
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>