Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Automatic refresh every 5 seconds possible?

Discussion in 'Information Technology' started by Gary, Oct 27, 2005.

  1. Gary

    Gary
    Expand Collapse
    Guest

    I have a datasheet which is a subform on a form,
    my database is going to be used by about 10 users, so i need to make
    sure the data is constantly uptodate.

    how do i refresh the form's data in my datasheet every 5 seconds?

    thanks,

    gary.
     
  2. RuralGuy

    RuralGuy
    Expand Collapse
    Guest

    Every form in Access has an OnTimer event and a TimerInterval. Set them up to
    do the work for you.

    On 26 Oct 2005 07:13:49 -0700, "Gary" <garyusenet@myway.com> wrote:

    >I have a datasheet which is a subform on a form,
    >my database is going to be used by about 10 users, so i need to make
    >sure the data is constantly uptodate.
    >
    >how do i refresh the form's data in my datasheet every 5 seconds?
    >
    >thanks,
    >
    >gary.


    _______________________________________________
    hth - RuralGuy (RG for short)
    Please post to the NewsGroup so all may benefit.
     

Share This Page