By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 959 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

How to display The values of a query

P: 86
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
Sep 7 '07 #1
Share this Question
Share on Google+
5 Replies


hariharanmca
100+
P: 1,977
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.
Sep 7 '07 #2

QVeen72
Expert 100+
P: 1,445
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
Sep 7 '07 #3

P: 86
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
Sep 7 '07 #4

QVeen72
Expert 100+
P: 1,445
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
Sep 7 '07 #5

P: 86
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
Sep 7 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.