Creating Forms with Results Stored in mdb / Query Forms

1. Put all radio buttons, text boxes, lists, etc. onto the form and rename them appropriately (hint:  use Form Field Properties).

2. Right-click on the form, choose "Form Properties":

3.  Make sure "Send to database" is selected, and then click on the "Options..." Button shown above to produce the following window:

4.  Click on the "Create Database" button shown above.

5.  Then choose "OK" on the pop up message to save the database created.

6.  Click on the "Saved Fields" tab and make sure you have everything labeled the   way you want it to be.  If not, go back and rename your fields.

To move on, click the "OK" button shown above to exit this screen.

7.  Click on "File", down to "Preview in Browser", select "Preview", and submit an entry in your form.  Once you submitted an entry, a confirmation notice should pop up.  You can then go into your database you created earlier and view your results.

8.  To set up a query for your results, start a new page in your folder on your web site.  

9.  Next, if you want to put in other fields from your database go to Insert, Database, and over to Results ( the name of your database).  A database wizard will pop up.  Shown below is the first step of the wizard.

10.  Choose "Use an existing database connection", and then click next.

11.  Using your database source (Results) you can click Next to move on.

12.  In step 3 it allows you to edit what you want in your query from the list of fields in your database.  Shown Below.

13.  Click on the "More Options.." button shown in the middle of the window below.

14.  Click on the "Criteria.." Button shown below.

15.  On this window choose the "Add" button.

16.  In the Add Criteria window, select your Field Name to be used and click "OK".

Click on "OK" again, and one more time if you don't need to modify your work.

17.  Click on the "Edit List..." if you would like to make changes on what shows up in the query.  Select the ones you want to remove from the Display fields..

18.  Click on "OK" to exit this screen shown above, once you are finished selecting your fields.  Then click on the "Next" to advance to step 4.

19.  For this next step above, choose the format you would like for your query.  Then click Next.

20.  Step Five, choose the "Display all records together" and click the Finish button.

21.  A pop up message might ask you to change your ".htm file" to an ".asp file".  Go ahead and rename it with the ".asp" extension.

Hint:  For a Drop Down Text in a query, you will have to go back to your original database page and copy the Drop Down Text and paste it over the one created for you in the new query.

22.  Next step is to go "File", and then "Preview in Browser" to check your work