automate Exports for every 2 minutes

[jmeckley]

I need to export 3 files from access the exportation works, my problem is automating this export to occur every 2 minutes. i looked at Access Help and from what they have told me i now have the following code in place:

***********************************************************
Private Sub Form_Load()
'Export Information every 2 minutes
Me.TimerInterval = 120000
End Sub
***
Private Sub Form_Timer()
'variables
'Export code
End Sub
***********************************************************
I open the form, but nothing happens. What part of the code am i missing?

thank you for help
Jason Meckley
Database Analyst
WITF

Jason Meckley
Database Analyst
WITF

 

[jmeckley]

I got it working, this does work, i just had the interval value set too high. (extra zero) Jason Meckley
Database Analyst
WITF

 

[FancyPrairie]

It looks ok to me. The only thing I can suggest is to verify that the OnTimer event is set to [EventProc]. Sometimes, after writing the code, I mistakenly clear the property (code still exists though).

Something to eliminate as a possible problem.