TimerInterval not working

  • Thread starter Thread starter caris111hk
  • Start date Start date
C

caris111hk

I have an access db application which needs to call the macro on
startup. The macro is to call the function opening two forms on
startup and set the TimerInterval of two forms.

Public Function auto_login()

DoCmd.OpenForm "frm_A"
Forms![frm_Import&Export].TimerInterval = 300000
DoCmd.OpenForm "frm_B"
Forms![frm_TREATS_ftp].TimerInterval = 120000

End Function

However only the Timer for form B (at the toppest) works. It works
for form A but not B if I open form B first and then A later. Is
there any way to solve the problem?

Regards
Caris
 
Caris,

This seems a litle simplistic, but I'm not sure why you are opening "frm_A"
and then setting the timer interval on "frm_Import&Export".. Have you tried:
Public Function auto_login()

DoCmd.OpenForm "frm_A"
Forms![frm_A].TimerInterval = 300000
DoCmd.OpenForm "frm_B"
Forms![frm_B].TimerInterval = 120000

End Function
Click to expand...

--
Email address is not valid.
Please reply to newsgroup only.


[email protected] said:
I have an access db application which needs to call the macro on
startup. The macro is to call the function opening two forms on
startup and set the TimerInterval of two forms.

Public Function auto_login()

DoCmd.OpenForm "frm_A"
Forms![frm_Import&Export].TimerInterval = 300000
DoCmd.OpenForm "frm_B"
Forms![frm_TREATS_ftp].TimerInterval = 120000

End Function

However only the Timer for form B (at the toppest) works. It works
for form A but not B if I open form B first and then A later. Is
there any way to solve the problem?

Regards
Caris
Click to expand...
 
Back
Top