November 9, 2008
Let users view Web pages from within an Access form
- Date: September 2nd, 2008
- Author: Mary Ann Richardson
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).
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).
Figure B
-
Type the following code at the prompt:
Private Sub Text17_AfterUpdate() Dim varAddress As String varAddress = Me.Text17 Me!WebBrowser6.Navigate varAddress End Sub
-
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
cialis discount price in place” width=”500″ height=”170″ />
Leave a comment
You must be logged in to post a comment.