Re: HELP! Need Access DB to show realtime changes in different location

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
news:%23RVdZyTbHHA.2408@xxxxxxxxxxxxxxxxxxxxxxx
You can set the form's TimerInterval property to an appropriate time (its
value can be between 0 and 65,535 milliseconds), and put code in the forms
Timer event to do a requery (using Me.Requery)


Hi Doug,

Wouldn't that have the unwanted side-effect of setting the current record as
the first in the set? Would Refresh be a better alternative?

Regards,
Keith.


.

Relevant Pages

  • Re: HELP! Need Access DB to show realtime changes in different location
    ... forms Timer event to do a requery ... Wouldn't that have the unwanted side-effect of setting the current record ... A lot depends on what the users want, but I think a Requery is what's ... You can always bookmark the current row, do the requery, then ...
    (microsoft.public.access.forms)
  • Re: Timer not being time-true
    ... Windows works by sending message on a queue. ... pumps a message and executes it... ... >I have a form that requeries data every 20 seconds based on a timer event. ... > sometimes the requery intervals are longer than 20 secons - sometimes as ...
    (microsoft.public.access.formscoding)
  • Time outs and state machines
    ... I have a state machine that sends messages to an external device. ... the state machine waits for 20 milliseconds. ... receiving device before the timer event has elapsed, it stops the timer, ... The ACK message gets put on the queue and immediately after the ...
    (comp.object)
  • Re: List box selection and requery
    ... Why not do away with the timer event and instead requery the listbox ... >must be performed on the selection they choose. ... I need to be sure that the deselection only ...
    (microsoft.public.access.formscoding)
  • Re: How do i make text in a control on a form flash
    ... Access cannot give you blinking text ... You can achieve it if program the Timer event of the form, ... TimerInterval in milliseconds. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.forms)