Refuses to refresh

[cymrudesign]

i have a form with 4 subforms on it informing the amount of calls etc taken and im trying to get it to autorefresh avaery 30 secs but it refuses to do it . I have folloed advice in other threads but just can get it to work.....Question do i have to set up refreshes on the subforms or just on the containing form ? im running a split DB across network

 

[KenHigg]

a. I assume you use the timer properties to trigger the requerys
b. Wouldn't it be easier to simply try requerying the subforms to see if that works than to post the question here and wait for a response?

 

[cymrudesign]

I have tried it on one of the subforms and it does not seem to work.....im using the timer event but i think that im doing something wrong in the event procedure to go along with it im using Me.refresh
i was just wonering if i am completly off track

 

[MaliciousMike]

I have tried it on one of the subforms and it does not seem to work.....im using the timer event but i think that im doing something wrong in the event procedure to go along with it im using Me.refresh
i was just wonering if i am completly off track

Set every forms timer individually. They should all be in sync when you open the main form.

timer interval would be... er... 30000? it works in thousandths doesn't it?

 

[cymrudesign]

the timer is not a problem its the event i seem to be having the problem with ........i am putting Me.refresh in the builder is that right /

 

[MaliciousMike]

the timer is not a problem its the event i seem to be having the problem with ........i am putting Me.refresh in the builder is that right /

Private Sub Form_Timer()
me.refresh
End Sub

That should work...

Do you get an error at all or does it just not want to work?

 

[cymrudesign]

where would i put ???
Private Sub Form_Timer()
me.refresh
End Sub

As i think this is my problem.....

 

[MaliciousMike]

where would i put ???
Private Sub Form_Timer()
me.refresh
End Sub

As i think this is my problem.....

I think if you put it in every subform, then when you open the form they should all get to 30 seconds at the same time.
To be perfectly honest with you i've never used timers for a form with subforms, but logically, this should work.
just click those three dots in the event tab and you're away i think.

 

[cymrudesign]

Yes it works if i do the timer event on the main form. It then refreshes the subforms on the page .........many thanks !!

 

[MaliciousMike]

Yes it works if i do the timer event on the main form. It then refreshes the subforms on the page .........many thanks !!

Glad to help.

I'm not a pro with access but coming here and reading random topics has taught me a lot!

I suggest coming here even if you don't need help, it's good for learning new things about access.

 

[MaliciousMike]

Yes it works if i do the timer event on the main form. It then refreshes the subforms on the page .........many thanks !!

Glad to help.

I'm not a pro with access but coming here and reading random topics has taught me a lot!

I suggest coming here even if you don't need help, it's good for learning new things about access.

 

[cymrudesign]

i wish i had the time .....learninglots of other things as well css html php..... shame we all couldnt have one coding language ...that would be a start lol