|
|
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. |
|
Subject:
Re: Microsoft Access Query Results
Answered By: dewolfe001-ga on 27 Jun 2002 17:16 PDT Rated: |
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:
Chuckbo's free comment was better and faster than the paid answer. |
|
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 |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |