Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    How to access the URL address (Access 2003)

    I have the following code, what i would like to do is get a string from the URL.
    <pre> Dim ieSrc As New InternetExplorer 'Need ref to Microsoft Internet Controls
    'Load web page
    With ieSrc
    .Visible = True 'show window and load page
    Dim sN As String
    sN = "http://www.tabvic.info/"
    .navigate sN
    While Not .readyState = READYSTATE_COMPLETE
    Sleep 500 'wait 1/2 sec before trying again
    Wend
    </pre>


    what would be the command to access the URL,
    i tried:
    dim strURL as string
    strURL = ieSrc.Address

    to no avail, it errors out.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: How to access the URL address (Access 2003)

    Patt

    You can get the URL with ieSRC.LocationURL
    Regards
    John



  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: How to access the URL address (Access 2003)

    Thanks John,

    I will give that a try.

Posting Permissions

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