Monday, October 4, 2021

Add web browsing to a form

Use the Web Browser Control to specify a URL and show web pages on a form. You can map Access fields to URL parameters and create dynamic web pages for each form record. you can also browse files and folders by specifying a file URL.   

Add a Web Browser Control to a form

Change the position and size of the Web Browser Control

Modify the control source of a Web Browser Control

Add a Web Browser Control to a form

Adding a Web Browser Control to a form is similar to other controls, except that the control source is a URL.

  1. In the Navigation Pane, right click the form to which you want to add a Web Browser Control, and then select Layout View.

  2. On the Design tab, in the Controls group, select Web Browser Control.

  3. Position the pointer where you want the control, and then click to place it. Access opens the Insert Hyperlink dialog box.

    Insert Hyperlink dialog box

  4. Do one of the following:

    Add a simple URL

    You want the same web page to display for each record in the form. For example, the Web page is a help site or supplementary information for the user.

    1. Select Browse the Web to the right of the Address box.

    2. When the page you want is displayed in your browser, copy the URL from the address bar, and then close the browser.

    3. In the Insert Hyperlink dialog box, select OK.

    Add a URL with a query string

    You want to display a different web page for each record in the form. You can use a Query string which assigns values to parameters. For example, the Web page is a map that varies based on address fields in each record.

    1. Select Browse the Web to the right of the Address box.

    2. In your Web browser, navigate to the page you want displayed in the control.

    3. In the Insert Hyperlink dialog box, paste the URL into the Address box, and then press the TAB key.

      Access clears the Address box, and separates (or parses) the URL into the appropriate boxes: Base URL, Paths, and Parameters. The complete URL is displayed in a box below the Paths and Parameters lists.

    4. To set the Web Browser Control so that its URL changes based on the data that is displayed on your form, replace the appropriate URL components with expressions that refer to the appropriate controls on the form. For each component that you want to replace:

      1. Click the path or parameter that you want to replace, and then click the Build button Button image.

      2. In the Expression Builder dialog box, if the element lists are not displayed, click More >> to display them.

      3. In the element lists, find the control that contains the data you want to be substituted for that path or parameter, and then double-click it to add it to the expression box.

      4. If there are any other calculations that must be done with the value, add the necessary operators and expression elements, and then click OK to close the Expression Builder.

      For more information about creating an expression, see Use Access expressions.

    5. In the Insert Hyperlink dialog box, select OK.

You can also type the base URL, paths, and parameters directly into the boxes. For more information about creating Bing maps, see Bing Maps Documentation.

Top of page

Change the position and size of the Web Browser Control

When you first place the Web Browser Control on a form, it might occupy a fairly small cell in a layout. In most cases, you will need to adjust the layout to show as much of the Web page as possible. A good way to get started is to merge the cell that contains the control with adjacent empty cells:

  1. Select the cell that contains the Web Browser Control.

  2. Hold down the CTRL key and select any empty adjacent cells that you want the control to occupy.

  3. On the Arrange tab, in the Merge / Split group, click Merge.

  4. Resize the resulting cell by selecting it and dragging its edges until it is the size you want.

Top of page

Modify the control source of a Web Browser Control

After adding a Web Browser Control to a form, you might need to make further modifications to its control source (URL). Use the following procedure to open the Insert Hyperlink dialog box so that you can make changes.

  1. In the Navigation Pane, right click the form to that contains the Web Browser Control, and then click Layout View.

  2. Right-click the Web Browser Control, and then click Build Hyperlink.

  3. In the Insert Hyperlink dialog box, make the necessary changes to the URL components, and then click OK.

Top of page

Top of page

No comments:

Post a Comment