Automated the command button?

[mapperkids]

Hi,

I have a button called "Update" in a form, when user clicking on it, it will connected to the back-end mainframe and update some data on the access table.

Now, I want to take away that button from the user and setup a separate PC to act as press than "update" button every 5 mins.

What I have to change the code inside that "update" button to ask it run every 5 mins by itself.

Thanks!

[leinad31]

Move the code to a timer... since the timer can't do 5 mins duration on its interval property you will have to maintain another variable to keep track of minutes... just Mod the variable by 5, if remainder zero then do rest of code.