Crosstab query, ADO Query, Parameters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Suawek - 20 Dec 2005 17:17 GMT

I created a crosstab query, added in the Design mode parameters and without
any problems I can open it when the form containing parameters is open. But
when I would like to start the same query using an ADO command it always
generates an error (missing parameters). Do I need to redeclare parameters if
they are available from the form?
crosstab query - qInterimSaffronCrosstabAverageIND
parameter - [Forms]![frmDatePicker]![Text63] Integer
form name - frmDatePicker

code -
rst1.Open "qInterimSaffronCrosstabAverageIND", cnn1, adOpenStatic,
adLockOptimistic, adCmdTable
(frmDatePicker open when the command is executed)

error - No value given to one or more parameters

Reply to this Message

Suawek - 20 Dec 2005 17:41 GMT

of course when I am trying to run the ADO query the form containing the
parameters is open

> I created a crosstab query, added in the Design mode parameters and without
> any problems I can open it when the form containing parameters is open. But
[quoted text clipped - 11 lines]
>
> error - No value given to one or more parameters

Reply to this Message