Results 1 to 3 of 3
  1. #1
    Ryan455 is offline Novice
    Windows Vista Access 2016
    Join Date
    Mar 2018
    Posts
    1

    RSS Feed Auto refresh


    Hi there,

    To start I have barely no experience with Access or VBA so please bear with me!

    So I want to create a database that imports data from an RSS feed which I have managed to do successfully, now I just need to be able to make this autorefresh say every 10 minutes. What's the best way for me to do this?

    Thanks
    Ryan

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    make a form, set the timerInterval = 600000 (10 min, since 1000 = 1 sec)
    the form must stay open so the timer can tick.

    in the ON TIMER event, refresh (Import) your data, so every 10 min, the ON TIMER event runs.
    Code:
    Private Sub Form_Timer()
      LoadMoreData
    End Sub

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Have a hidden form that runs at start up and stays open whilst your database is running.
    Add a form timer event to the form and set the timer interval equal to 600000
    The units are in milliseconds so that value is equal to 10 minutes

    In the form timer event run your code to update the RSS feed.
    BTW I think others might find the idea useful so it would be good if you could post your database when it's done

    EDIT Ranman got in first while I was typing
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. RSS Feed?
    By dhicks in forum Access
    Replies: 0
    Last Post: 07-14-2017, 10:26 AM
  2. Add RSS feed to a report
    By bid19123 in forum Reports
    Replies: 1
    Last Post: 04-28-2016, 01:36 PM
  3. Auto Refresh - ReApply Filter
    By jnoonan22 in forum Forms
    Replies: 6
    Last Post: 10-25-2014, 12:07 AM
  4. Replies: 7
    Last Post: 06-27-2013, 10:56 AM
  5. auto refresh the table content
    By mohammad8065 in forum Access
    Replies: 1
    Last Post: 02-27-2012, 01:54 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums