Maggie Whittington
District TRT for Instructional Web Sites
http://teach.fcps.net/trt1 
Email - maggie.whittington@fayette.kyschools.us
Office Phone – 381-4125


How to Create An Online Form Using FrontPage 2000

To Create a Form:
  • Open a new page.
  • Type the name of the page.
  • Choose File, Save As
  • Save as an .asp file

  • Choose Insert, Form, Form
    Note: This will insert an area with a dotted line around it. Everything added inside that dotted line applies to that form.
  • To add fields to the form: Choose enter and then use the up arrow to position the cursor to the top of the form

  • Type in the information for the form -- example: Presenter

  • Next insert a form field for that information -- example: for Presenter, choose Insert, Form, One-Line Text Box

  • Right click on the form field -- example: the one-line text box.

  • Choose Form Field Properties

  • In Text Box Properties, give the field a name to identify it -- example:  Presenter

  • Next, make changes to the width. (A good width for names is 40.)

  • Choose OK

  • Repeat the steps until you've entered all your data.

  • Save the page

Next, Tell FrontPage How To Handle This Form (Where To Store Results)

  • Right click anywhere on the form (inside the dotted line)

  • Choose Form Properties

  • In the Form Properties box, choose Send to database

  • Next, choose the Options button (lower left-hand corner)

  • Choose the Create Database button

  • When you get the message: "FrontPage has successfully created a database for you...," choose OK

  • Choose OK two more times

  • Save the page

Note: If you make changes in the form after you have created the database, you must update the database.  To update the database, follow the steps above, but choose Update Database instead of Create Database.

Now you've created an online form.

Next, create A Page To Display Results from the Database in the Browser

  • Open a new page

  • Type Results on the page

  • Choose File, Save As

  • Save as an .asp file

 

  • Choose Insert, Database, Results

  • In the Database Results Wizard, Step 1, choose Next.  (Your form name should be listed in the drop-down box.)

  • In the Database Results Wizard, Step 2, choose the Next button

  • In Step 3, choose the More Options button

  • In the More Options box, choose the  Criteria button. Note: You may choose turn off the Limit number of returned records to: option

  • In the Criteria box, choose the  Add button to add fields to be displayed in the Search Form

  • In the Add Criteria box, choose the  Field Name: drop-down box. Choose the field you want displayed.

  • In the And/Or: drop-down box, choose  Or

  • To add the next field to be displayed on the Search Form, choose  Add again and repeat the steps until all of the fields have been added.

  • Choose  OK two times

  • Choose  Next two times

  • In Step 5, choose  Display all records together.
    Note:  Make sure the box for  Add search form is checked.

  • Choose  Finish

  • Save the page.

FYI:

Inserting a table for the form fields is a good design/organizational tool.

Choose form fields which match the type of information you are requesting.  For example,  

  • One line textbox -- names, addresses, etc.

  • Scrolling textbox -- areas that require long answers, such as comments

  • Dropdown menu -- good for when several options are available

  • Check box -- good for when more than one choice is requested

  • Radio button -- good for when only one choice is requested  (allows only one choice)


Prepared by Maggie Whittington
maggie.whittington@fayette.kyschools.us