Run MacroOnce Daily on Form Open

  • Thread starter Thread starter AccessIM
  • Start date Start date
A

AccessIM

I have created a macro that will run three separate append queries and want
it to run when a specific form is opened. To avoid duplicates, I only want
this macro to run the first time the form is opened.

Is there a way to limit the number of times to one regardles of the number
of times the form is opened?

Thank you in advance.
 
You can have an unbound text box on the form.

Form event 'On Open' run 'Macro_Once_Today' that has condition to check the
text box < Date() to run your append queries. Next action to Set Value text
box to Date().
 
Should read --
Form event 'On Open' run 'Macro_Once_Today' that has condition to check the
text box < Date() to run your append queries. Next action to Set Value text
box DEFAULT to Date().
 
Back
Top