ADP Query Problem

D

Dale

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
 
M

Maurice

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
 
D

Dale

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

Maurice said:
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


Dale said:
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
 
M

Maurice

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


Dale said:
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

Maurice said:
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


Dale said:
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
 

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