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().
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compact & Repair, Open table, close table, then run macro 3
Controlling flow of actions 2
macros with a macro 1
how to run a query upon a form closing 1
Run a macro and pause before running second macro 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
looping macro 9
Access Command to run access, open to specific form and specific record 1

Back
Top