Crosstab query, ADO Query, Parameters

G

Guest

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
 
G

Guest

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

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

Top