Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Open a URL from Access (https://www.askmehelpdesk.com/showthread.php?t=47889)

  • Dec 11, 2006, 10:26 AM
    VectorGES
    Open a URL from Access
    I have a tickler data base to remind me to visit web sites. A query returns the sites to be visited based on a frequency and "last visited" date. I can double click the hyperlink in the form to start Explorer, but I would like to do this automatically. I have a subroutine to start IE for a particular web site. I need the code to loop through the hyperlinks returned by my query to execute te subroutine for each row returned. Can someone help me?

    Thanks,
    George
    Conway, SC
  • Dec 11, 2006, 11:14 AM
    ScottGem
    You can use the Application.FollowHyperlink command in a loop that reads each record from a query. That should open an instance of IE with that URL. You can pause the loop after each one or have them all opened.

  • All times are GMT -7. The time now is 09:39 AM.