FrontPage Tips from http://microsoftfrontpage.com

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

 

**Applies to:
**     Microsoft® FrontPage®

Summary   We have recently closed the Web site located at http://microsoftfrontpage.com and moved the content to either http://www.microsoft.com/frontpage or the Microsoft FrontPage section of MSDN. We have aggregated five existing FrontPage tips from the closed Web site into this article. (5 printed pages)

Contents

Using the Microsoft Script Editor
Using the Database Results Wizard in FrontPage 2002 for Information Filtering
Using the Database Interface Wizard
Changing Database Results Field Labels in FrontPage 2002 Webs
Adding New Values to the Substitution Web Component

Using the Microsoft Script Editor

You can quickly launch the Microsoft Script Editor from within Microsoft FrontPage 2002 to add text, edit HTML tags, and add or edit any Microsoft Visual Basic® Scripting Edition (VBScript) or JavaScript on your web site. You can also view your page in the Script Editor as it would appear in a Web browser.

To start using the Microsoft Script Editor, open a Web page in FrontPage 2002 and do the following:

  1. On the Tools menu, point to Macro, and then click Microsoft Script Editor.
    Note You must have at least one file open in Page view for the Microsoft Script Editor option to be available.

  2. If you are prompted to install Microsoft Script Editor, click Yes.

  3. In HTML view, edit your file and save changes in the Script Editor.

  4. To view your HTML file as it will be displayed in the browser, click the View in Browser command on the File menu.

    Aa140115.odc_fptips_01(en-us,office.10).gif

**Tip   **When you make changes to your FrontPage 2002-based Web page in the Script Editor, you are actually changing a separate copy of the HTML document. These changes are now out of sync with the copy in the FrontPage copy. To sync the changes you made to the other copy of the page open in FrontPage, click Refresh on the View menu.

For more information about Microsoft Script Editor, see Microsoft FrontPage 2002 or Microsoft Script Editor Help.

Using the Database Results Wizard in FrontPage 2002 for Information Filtering

In Microsoft FrontPage version 2002, the Database Results Wizard enables you to filter database results to display only the records that match the criteria you set. When the page is browsed, only matching records are displayed. You can sort records as well.

If your Web site doesn't have database functionality already, you need to add it (see the "Using the Database Interface Wizard" section below).

To use the Database Results Wizard to help you build a query to filter database results on your Web site using FrontPage 2002, do the following:

  1. On a page with an existing database results region (such as results_page.asp), right-click the database results region, and then click Database Results Properties. The Database Results Wizard starts.

  2. Click Next to get to Step 3 of the wizard.

  3. In Step 3 of the wizard, click More Options, click Criteria, and then click Add.

  4. In the Field name box, select the field that contains the values you want to look for. For example, from a database of products, you could select the ReorderLevel field.

  5. In the Comparison box, select the type of comparison you want to perform. For example, to filter for all products reordered when stock is zero, you would select Equal in the Comparison box.

  6. In the Value area, enter the value that you want to filter on.
    For example, to display all products reordered when stock is zero, you would enter 0 in the Value box.

  7. Clear the Use this search form field check box.

  8. If you're finished specifying criteria, click OK three times to close criteria setup and continue using the wizard.

  9. To continue to build your query, select And or Or in the And/Or box, and then click OK. In the Criteria dialog box, click Add, and repeat steps 3 through 6 of this procedure. When you have finished, click OK.

  10. To exit the wizard, click Next twice and then Finish and save the page.
     

    Aa140115.odc_fptips_02(en-us,office.10).gif

For more information about the Database Results Wizard, see Microsoft FrontPage 2002 Help.

Using the Database Interface Wizard

The Database Interface Wizard in Microsoft FrontPage version 2002 generates everything you need to add database functionality to your Web site including a database, the forms, and Web pages required. With a Web front-end to your data, specific users can edit or delete records from the database through a web page that's created with this wizard. And you can allow visitors to add new records and view existing ones as well as filter the data to more quickly find what they are looking for.

To add database functionality to your Web site using FrontPage 2002, do the following: 

  1. On the File menu, select New then Page or Web.
  2. From the Task Pane, select Web Site Template.
  3. Click on Database Interface Wizard.
  4. Check the Add to current Web box and click OK, then let the wizard walk you through database and page setup.

**Tip   **To view the data once you set up the connection and complete the steps in the Database Interface Wizard, your Web site must be hosted or published on a Web server configured with:

Active Server Pages (ASP)

ActiveX Data Objects (ADO)

Microsoft FrontPage 2000 Server Extensions (or later) or SharePoint™ Team Services

Ask your Internet service provider (ISP) or Web server administrator whether your Web server is configured with these options.

For more information about the Database Interface Wizard, see Microsoft FrontPage 2002 Help.

Changing Database Results Field Labels in FrontPage 2002 Webs

When a database results region is formatted as a table, the table column headings are called field labels. In Microsoft FrontPage version 2002, you can rename or format the field labels as needed. For example, you may want to modify the field labels to use familiar names instead of the assigned values. First you need to add database functionality to your web site if it doesn't have it already, (see the "Using the Database Interface Wizard" section above).

To change a database results field label your Web site using FrontPage 2002, do the following:

  1. In Page view, open a database results page (for example, results_page.asp).
  2. To replace a label with a new name, select the field label you want to modify, and then type a different label.

**Tip   **In a database results region formatted as a table, field labels are displayed in bold text at the top of each column. In a database results region formatted as a list, field labels are displayed in bold text to the left of the value of the field.  

Aa140115.odc_fptips_03(en-us,office.10).gif

For more information about changing fields, see Microsoft FrontPage 2002 Help.

Adding New Values to the Substitution Web Component

The Substitution Web Component helps you quickly insert repetitive information in your Web pages. Microsoft FrontPage version 2002 comes with four Substitution values already enabled. These have already been defined for you and are:

  • **Author   **The author of a page.
  • **Description   **This is populated by the Comments field under the Summary tab in File Properties.
  • **Modified By   **Who last modified the page.
  • **Page URL   **The page's URL.

If you would like to add your own Substitution components such as a company e-mail address you can do that as well.

To create your own Substitution values and use them as a single source of content in multiple locations, open a new or existing Web in FrontPage 2002 and do the following:

  1. In Page view, on the Tools menu, click Web Settings, and then click the Parameters tab.
  2. Click Add.
  3. In the Name box, type a name for the variable. This is what you will call the variable.
  4. In the Value box, type a value for the variable. This is what will be displayed on the page.
  5. Click OK.
  6. Position the insertion point in a page where you want to display the variable.
  7. On the Insert menu, click Web Component.
  8. In the left pane, click Included Content, and in the right pane, double-click Substitution. 
  9. In the Substitute with box, click a variable from the list.

**Tip   **The four default Substitution values are captured from the File Properties dialog box. In Folder List view, right-click any one of the files and select Properties. Under the Summary tab in the Comments field, you will see the data used to populate the Description Substitution value. This is blank by default. You can add or change this information by editing the Comments field. 

For more information about Web Components, see Microsoft FrontPage 2002 Help.