queries
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Queries

Queries

resolvedResolved · Low Priority · Version 2003

replyReply Thu 19 Mar 2009, 16:29Delegate Fiona said...

Fiona has attended:
Access Intermediate course

Queries

How do you create a query and make it appear in form view?

For upcoming training course dates see: Pricing & availability

replyReply Tue 24 Mar 2009, 11:08Trainer Stephen said...

RE: Queries

Hi Fiona

Thank you for your question

First create your query, with all the fields required.

Then create a form and set its data source equal to the query that you have created. When you open the form the query will first run and feed its data into the form. You will see only the form with the query's data, and not the query itself.

If you are running a parameter query, opening the form will first run the query and as a result the dialog boxes prompting for parameter values will run, and when parameters are entered the form will open

Hope this is help full

Regards

Stephen

Tue 31 Mar 2009: Automatically marked as resolved.

 

Please browse our web site to find out more about
advanced micorosoft access training and other Microsoft training courses.

Access tip:

Relationship maps

It is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes


Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard