Auto Refresh queries in Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Morning,

Could someone point me in the right direction to Automate a Query Refresh
from a Form...

I have a look on the helper for OLD/DDE Links which may.. help but it's
greyed out on my menus.

I want to achieve a simple query that refreshes every 5 minutes.

Kindest Regards

Jason
 
Every time you open a query the data in it is refreshed,

Is that query open all the time?
Is there a form linked to this query? If that the case you need to refresh
the form

Me.Requery

To set the form to refresh every 5 minutes, use the form OnTimer Property to
set the code above, and use the TimerInterval Property to set the time
between each time the OnTimer event will run

If i'm in the wrong direction, please post back with more information on
what you are trying to do.
 
Thanks for your reply.

I actually found similar info with the Access Macro's threads...

However ....

With the ontime property what is syntax(coding) in the event procedure , to
indicate a five minute refresh??

Regards

Jason
 
Sorry///


Sussed using the time interval and on time run query...

Playing with it now

Thanks again

Jason
 
Well,
60,000 = 1 minute
6 minutes = 300,000

So set the form TimeInterval = 300,000 so the code in the OnTimer propert
will run every five minutes
 
Still have issues .

I think I am almost there but I can get it to refresh still,

I have set the Timer Interval to 60,000 (1 min) and I have tried to build an
event procedure in 'On Timer' To Requery an open query screen but it don't
work???

I really want it to refresh an inbedded list box with the query running in
there

Could you help push me in the correct direction for how to code it???

Thanks again

Jason
 
BINGO!!!!!

Done the job

Thank you very much

Case closed ;)

Ofer Cohen said:
Try

Me.[ListBoxName].Requery

--
Good Luck
BS"D


Jai_Friday said:
Still have issues .

I think I am almost there but I can get it to refresh still,

I have set the Timer Interval to 60,000 (1 min) and I have tried to build an
event procedure in 'On Timer' To Requery an open query screen but it don't
work???

I really want it to refresh an inbedded list box with the query running in
there

Could you help push me in the correct direction for how to code it???

Thanks again

Jason
Click to expand...
Click to expand...
 
Back
Top