Google Answers Logo
View Question
 
Q: Microsoft Access Query Results ( Answered 2 out of 5 stars,   3 Comments )
Question  
Subject: Microsoft Access Query Results
Category: Computers > Software
Asked by: halejrb-ga
List Price: $4.00
Posted: 21 Jun 2002 05:29 PDT
Expires: 28 Jun 2002 05:29 PDT
Question ID: 31125
In Microsoft Access 2002, is it possible to display the results of a
query as a form instead of a datasheet?  If so, how do you do this? 
The default view of a query result seems to be a datasheet.
Answer  
Subject: Re: Microsoft Access Query Results
Answered By: dewolfe001-ga on 27 Jun 2002 17:16 PDT
Rated:2 out of 5 stars
 
What you do is make up your query. Then go to the FORMS tab, create a
new form and use the query you made as the data source for that new
form. You then have the choice of using a wizard or manually building
the form with the tools provided.
halejrb-ga rated this answer:2 out of 5 stars
Chuckbo's free comment was better and faster than the paid answer.

Comments  
Subject: Re: Microsoft Access Query Results
From: chuckbo-ga on 21 Jun 2002 06:59 PDT
 
If you're running a query and looking at the results directly from the
Query object, you will only be able to see those results in a
datasheet format. To view them as a form or a report, you need to
(1) create and save your query;
(2) create a form or report;
(3) in the properties for the form or report, specify the query that
you created as the datasource. (If you use the wizard to create the
form or report, specify the query name when it asks which table/query
is the source.)

If you're planning to do much with Access, you may want to get a copy
of Alison Balter's "Mastering Access 2002 Desktop Development" book;
it's very good for both beginners and advanced programmers.
Subject: Re: Microsoft Access Query Results
From: naomikate-ga on 21 Jun 2002 07:04 PDT
 
chuckbo-ga's answer is exactly right. I've also found some sites from
Microsoft's Developer Library (MSDN) which give more information-
The Data Behind Forms and Reports
----------------------------------
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/deovrTheDataBehindFormsReports.asp

and 
DLookup Function
----------------
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/acfctDLookup.asp

Basically, you can use DLookup to get a small amount of information
from a query into a form (for example, one field in a test box). If
you want the entire form to display results from one query, specify
the query as the form's datasource as suggested by chuckbo-ga.
Subject: Re: Microsoft Access Query Results
From: nekkidnoddy-ga on 26 Jun 2002 08:55 PDT
 
On top of the suggestions above, you could possibly make the datasheet
look like a form, by right cliking in the grey area and using 'Filter
By Form..' and 'Datasheet..' formatting

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy