ADP Query Problem

[Guest]

This is the first time I am using Access ADP to query an SQL Database, and I
am having problems with building the criteria. In MDB I had no problem
creating a form with multiple text boxes, and then creating independent
queries linked to those text boxes that run when activated from the form. A
sample criteria of what I had was something like this -
=[Forms]![Frm_TripTicket]![TripTicketScan]
This isn't working with ADP.
As this is my first time building queries in Access ADP, I feel stupid
asking this question. What am I doing wrong?

Thanks... Dale

 

[Guest]

Dale,

When using ADP the form offers you the parameter property in the forms
property. That's what you can reference in your query. So in the form
property parameter place the regular reference like in an MDB being
=[Forms]![Frm_TripTicket]![TripTicketScan] from that point on refer to the
control parameter.

Hop this will help you on your way. Not a stupid question...

Maurice

 

[Guest]

Maurice,
I'm confused, maybe I need to explain.
I have a form where I have 6 text boxes. After they are filled in, I press a
command button on the form that runs a module. This module runs multiple
queries that are outputed to a text file according to the criteria set in the
form.
Its the queries I am having problems with not the form. In MDB I set
criteria in the query on one of the text boxes as
=[Forms]![Frm_TripTicket]![TripTicketScan], which doesn't work in ADP.

Any direction here would be much appreciated.

Thanks... Dale

Dale,

When using ADP the form offers you the parameter property in the forms
property. That's what you can reference in your query. So in the form
property parameter place the regular reference like in an MDB being
=[Forms]![Frm_TripTicket]![TripTicketScan] from that point on refer to the
control parameter.

Hop this will help you on your way. Not a stupid question...

Maurice

This is the first time I am using Access ADP to query an SQL Database, and I
am having problems with building the criteria. In MDB I had no problem
creating a form with multiple text boxes, and then creating independent
queries linked to those text boxes that run when activated from the form. A
sample criteria of what I had was something like this -
=[Forms]![Frm_TripTicket]![TripTicketScan]
This isn't working with ADP.
As this is my first time building queries in Access ADP, I feel stupid
asking this question. What am I doing wrong?

Thanks... Dale

 

[Guest]

Dale,

Sorry for the misunderstanding. I've created the using forms that's way I
went straight for the forms parameter. As for queries I'm a little confused
because i work the same way you do. In such cases I always turn to VBA where
you can apply cmd parameters. But that doesn't answer your question to the
direct querygrid. Have you tries posting in ADP group? I'm curious too how
this can be done.
Sorry for lacking a solution for you...
--
Maurice Ausum

Maurice,
I'm confused, maybe I need to explain.
I have a form where I have 6 text boxes. After they are filled in, I press a
command button on the form that runs a module. This module runs multiple
queries that are outputed to a text file according to the criteria set in the
form.
Its the queries I am having problems with not the form. In MDB I set
criteria in the query on one of the text boxes as
=[Forms]![Frm_TripTicket]![TripTicketScan], which doesn't work in ADP.

Any direction here would be much appreciated.

Thanks... Dale

Dale,

When using ADP the form offers you the parameter property in the forms
property. That's what you can reference in your query. So in the form
property parameter place the regular reference like in an MDB being
=[Forms]![Frm_TripTicket]![TripTicketScan] from that point on refer to the
control parameter.

Hop this will help you on your way. Not a stupid question...

Maurice

This is the first time I am using Access ADP to query an SQL Database, and I
am having problems with building the criteria. In MDB I had no problem
creating a form with multiple text boxes, and then creating independent
queries linked to those text boxes that run when activated from the form. A
sample criteria of what I had was something like this -
=[Forms]![Frm_TripTicket]![TripTicketScan]
This isn't working with ADP.
As this is my first time building queries in Access ADP, I feel stupid
asking this question. What am I doing wrong?

Thanks... Dale