D
DAVID BORDER
I would like to run a Macro if it has been more than six days since another one has run. I was thinking I could have a table updated with a date each time the macro is run and then for example it will look at the last date in the table, see that it is less than six days and not run the other macro.
One Macro is going to export table onto a server for backup. I have an exit button on my form so I will attach the macro to that. if the backup was run within the last six days I want it to go ahead and exit. if it has been more than 6 days, I want it to send a copy of the table to the server, update the next record in my date table to today's date and then exit.
Or would it be easier to set it up to run every Friday? I do not know how to do that either.
One Macro is going to export table onto a server for backup. I have an exit button on my form so I will attach the macro to that. if the backup was run within the last six days I want it to go ahead and exit. if it has been more than 6 days, I want it to send a copy of the table to the server, update the next record in my date table to today's date and then exit.
Or would it be easier to set it up to run every Friday? I do not know how to do that either.