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:
- Open the form in Design View.
- 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.)
- Click and drag in your form to create the Web browser control.
- Click the Text Box Control tool and then click and drag in your form to create the control.
- Click in the text box control label and type Web Address: (Figure A).
- Right-click the text box control and select Properties.
- Click in the After Update property box and then click the Build button (Figure B).
- Type the following code at the prompt:
Private Sub Text17_AfterUpdate()
Dim varAddress As String
varAddress = Me.Text17
Me!WebBrowser6.Navigate varAddressEnd Sub
- Press Alt + Q.
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.