Access 2010 features a new control that you can use to add Web content to a form. You can link the control to fields or controls in your database to dynamically change the pages that are displayed in the control. In this video, we show you how you can use address information in a database to create custom maps on Microsoft’s Bing Maps site.
In the video
Add a Web Browser Control to a form
Adding a Web Browser Control to a form is similar to the process of adding other controls, such as text boxes or command buttons. However, creating the control source (the Web page URL) can be somewhat complicated. Use the following procedure to get started.
- In the Navigation Pane, right click the form to which you want to add a Web Browser Control, and then click Layout View.
- On the Design tab, in the Controls group, click Web Browser Control.
- Position the pointer where you want the control, and then click to place it.
Access opens the Insert Hyperlink dialog box, where you can specify which Web site to display in the control. You can type the base URL, paths, and parameters directly into the boxes, but the easiest way to enter the URL is to browse to the site, copy the address, and then let Access parse the address into its component parts. Use the following steps to accomplish this task:
- Click the Browse the Web button to the right of the Address box.
- In your Web browser, navigate to the page you want displayed in the control. If the page you want is a “results” page of a search engine, enter a typical search term and search for it.
- When the page you want is displayed in your browser, copy the URL from the address bar, and then close the browser.
- In the Insert Hyperlink dialog box, paste the URL into the Address box, and then press TAB.
Access clears the Address box, and separates 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.
- If you want to display the same Web page regardless of what data is displayed on the form, click OK in the Insert Hyperlink box and continue with the next section. Otherwise, continue with the next step.
- To set the Web Browser Control so that its URL changes based on the data that is displayed on your form, you must replace the appropriate URL components with expressions that refer to the appropriate controls on the form. For each component that you want to replace:
- Click the path or parameter that you want to replace, and then click the Build button .
- In the Expression Builder dialog box, if the element lists are not displayed, click More >> to display them.
- 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.
- 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.
- Click OK in the Insert Hyperlink dialog box.
If you are having trouble constructing the correct URL for a particular site, you might need to consult the Help or support pages of that site for further information about how to build a URL.
For more information about creating an expression, see the articles Create an expression or Use the Expression Builder.
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:
- Select the cell that contains the Web Browser Control.
- Hold down CTRL and select any empty adjacent cells that you want the control to occupy.
- On the Arrange tab, in the Merge / Split.group, click Merge.
Resize the resulting cell by selecting it and dragging its edges until it is the size you want. To avoid resizing existing cells in the layout, you might want to insert new rows and columns into the layout, merge the Web Browser Control with those cells, and then resize it. Rows and columns can be inserted into a layout by using the commands in the Rows & Columns group on the Arrange tab.
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.
- In the Navigation Pane, right click the form to that contains the Web Browser Control, and then click Layout View.
- Right-click the Web Browser Control, and then click Build Hyperlink.
- In the Insert Hyperlink dialog box, make the necessary changes to the URL components, and then click OK.
Top of Page