How to display The values of a query

[ravindarjobs]

hello friends,
i am using ms access 2003.

i have a form.
and i want to show the results of a query output in the form.
the query is dynamic. it changes often.

for this purpose data grid suits well.
but we dont have data grid in ms access(by default).

so what should be my approach to display the results of the query?


Thanq

[hariharanmca]

hello friends,
i am using ms access 2003.

i have a form.
and i want to show the results of a query output in the form.
the query is dynamic. it changes often.

for this purpose data grid suits well.
but we dont have data grid in ms access(by default).

so what should be my approach to display the results of the query?


Thanq

I think this has to move in MS Access forum.

[QVeen72]

Hi,

Create a Query Object and
Create a Form Based on the Query Object and in runtime change the Query Parameters, And the show the form, Results will be automatically refreshed..


REgards
Veena

[ravindarjobs]

Hi,

Create a Query Object and
Create a Form Based on the Query Object and in runtime change the Query Parameters, And the show the form, Results will be automatically refreshed..


REgards
Veena

Thanq for your responses.

Veena if you dont mind, i dont know what a query object is.
do u mean creating a query manually through wizard?
can you please tell me?
else can you give a sample code.
if u cannot, can you please explain in detail.
.

please dont mind


Thanq

[QVeen72]

Hi Ravindra,

Yes, Create a New Query Thru Query Wizard Save the Query. And then Create a Form Based on this query. So if u change the query Parameters, and Run the Query, then the Results are displayed automatically..

Check This
or this

Regards
Veena

[ravindarjobs]

Hi Ravindra,

Yes, Create a New Query Thru Query Wizard Save the Query. And then Create a Form Based on this query. So if u change the query Parameters, and Run the Query, then the Results are displayed automatically..

Check This
or this

Regards
Veena

Thanq.

But isnt that query created by through wizard a standard one?

Means can we edit it at runtime?
how can we do that?
suppose i have created a query named "query1" through wizard, how can we edit this query at runtime?
veena, in my query the number of parameters too changes.
still are we able to display?
i am really glad to know this thing.
can you plase tell me how to do.

Thanq