Enterprise Software

Let users view Web pages from within an Access form

Your users don't have to waste time bouncing between Access and a Web browser. See how to add a control that lets them browse without ever leaving their form.

Do your users often need to stop and search the Web for data? Make it easier for them by adding a Web browser control to their forms. For example, say your users need to input the latest stock prices of the companies where your clients have placed investments. Follow these steps:

  1. Open the form in Design View.
  2. Click the More Controls button in the Controls toolbox. Scroll down to select Microsoft Web Browser. (In Word 2007, click the Active X button in the Controls group under the Design tab of Forms Design Tools. Scroll down to select Microsoft Web Browser and then click OK.)
  3. Click and drag in your form to create the Web browser control.
  4. Click the Text Box Control tool and then click and drag in your form to create the control.
  5. Click in the text box control label and type Web Address: (Figure A).

Figure A

text box control

  1. Right-click the text box control and select Properties.
  2. Click in the After Update property box and then click the Build button (Figure B).

Figure B

Web control

  1. Type the following code at the prompt:
Private Sub Text17_AfterUpdate()

Dim varAddress As String

varAddress = Me.Text17

Me!WebBrowser6.Navigate varAddress

End Sub

  1. Press Alt + Q.
Now when a user enters a Web address, the Web page displays in the Web browser control window, as shown in Figure C.

Figure C

browse in place


Miss an Access tip?

Check out the Microsoft Access archive and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox