Transform Statement Issue

[Guest]

I have a query set up that uses the contents of two text boxes on a form for
selection criteria. I am trying to use that query in another crosstab query
(using a transform statement) and I get an error "The Microsoft Jet database
engine does not recognize '[Forms]![ReportOutput]![cmbClientId]' as a valid
field name or expression." Is there anyway around this error & situation?

 

[Guest]

Does the query run ok? The form has to be open.

 

[Guest]

Yeah the form is open and the text boxes are filled in. I have had this
problem before with another db. I was able to get around it using a piece of
code to redo the querydef for that one. I knew what fields I was going to
use in that one, this one however needs to be more flexible and I cannot say
what fields may show up.

Thanks Karl for your help.

Does the query run ok? The form has to be open.

I have a query set up that uses the contents of two text boxes on a form for
selection criteria. I am trying to use that query in another crosstab query
(using a transform statement) and I get an error "The Microsoft Jet database
engine does not recognize '[Forms]![ReportOutput]![cmbClientId]' as a valid
field name or expression." Is there anyway around this error & situation?

 

[Duane Hookom]

Crosstab queries require that you enter the data types of all parameters.
Select Query->Parameters and enter:
[Forms]![ReportOutput]![cmbClientId] Integer (or whatever)

--
Duane Hookom
MS Access MVP

Yeah the form is open and the text boxes are filled in. I have had this
problem before with another db. I was able to get around it using a piece
of
code to redo the querydef for that one. I knew what fields I was going to
use in that one, this one however needs to be more flexible and I cannot
say
what fields may show up.

Thanks Karl for your help.

Does the query run ok? The form has to be open.

I have a query set up that uses the contents of two text boxes on a
form for
selection criteria. I am trying to use that query in another crosstab
query
(using a transform statement) and I get an error "The Microsoft Jet
database
engine does not recognize '[Forms]![ReportOutput]![cmbClientId]' as a
valid
field name or expression." Is there anyway around this error &
situation?

 

[Guest]

Duane that took care of the problem. I did not know that Parameters deal
even existed. I guess you learn something new every day!! I have fought
that problem many time and now thanks to you I have a way around it!!

Thanks again.

Crosstab queries require that you enter the data types of all parameters.
Select Query->Parameters and enter:
[Forms]![ReportOutput]![cmbClientId] Integer (or whatever)

--
Duane Hookom
MS Access MVP

Yeah the form is open and the text boxes are filled in. I have had this
problem before with another db. I was able to get around it using a piece
of
code to redo the querydef for that one. I knew what fields I was going to
use in that one, this one however needs to be more flexible and I cannot
say
what fields may show up.

Thanks Karl for your help.

Does the query run ok? The form has to be open.

:

I have a query set up that uses the contents of two text boxes on a
form for
selection criteria. I am trying to use that query in another crosstab
query
(using a transform statement) and I get an error "The Microsoft Jet
database
engine does not recognize '[Forms]![ReportOutput]![cmbClientId]' as a
valid
field name or expression." Is there anyway around this error &
situation?