Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Website within a form

    I found the following instructions on a tip website and thought i'd give it a try as i'm currently working on a database that could benefit from having a website open on the form itself.

    I'm running Access 97.

    I believe I have followed the steps correctly, but it doesn't work. I think this is due to .Navigate not being a correct keyword in Access 97, but i'm not sure.
    I tried the Access Help file and got a link to a MS site which wasn't there.

    Here are the instructions:
    1) Create a table of URLs
    2) Base a form on your table of URLs
    3) Add a text box and name it txtURL
    4) Click the More Controls button on the Toolbox
    5) Select Microsoft Web Browser from the list
    6) Add the new control to your form and name it msWebBrowser
    7) Open your form's module and enter the following statement in the form's Current event:
    Me.msWebBrowser.Navigate txtURL

    Does anyone know a way of getting this working in Access 97.
    The only VB I know is what i've seen other people do and thought "I'll remember that." - Not that much really, but I intend to learn.

    Most grateful for any help or advice given.

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Website within a form

    Hi,

    Skip steps 4, 5 and 6. These are not necessary.
    Change step 7.
    Application.FollowHyperlink me.[txtURL], , True, False

  3. #3
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Website within a form

    You may want to download and look at <A target="_blank" HREF=http://officeupdate.microsoft.com/downloadDetails/webtrack.htm>webtrack.mdb</A> provided through MS Office Update. There are a number of examples built in. Regarding use of the browser within access, I've found a number of valuable applications for my own projects from looking up postal codes to displaying maps by passing known information directly from forms.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •