467,207 Members | 1,283 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,207 developers. It's quick & easy.

How to display The values of a query

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
  • viewed: 1568
Share:
5 Replies
hariharanmca
1GB
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 1GB
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
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 1GB
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
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.

Similar topics

2 posts views Thread by erica | last post: by
3 posts views Thread by Miguel Dias Moura | last post: by
3 posts views Thread by Bob Sanderson | last post: by
5 posts views Thread by PHPBABY3 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.