Auto Refresh queries in Forms

[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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

Sorry///


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

Playing with it now

Thanks again

Jason

 

[Guest]

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

 

[Guest]

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

 

[Guest]

Try

Me.[ListBoxName].Requery

 

[Guest]

BINGO!!!!!

Done the job

Thank you very much

Case closed

Try

Me.[ListBoxName].Requery

--
Good Luck
BS"D

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