Help on running macro msgbox on certain dates

[bishop]

You are correct on the last. I will only do it once a month and picked the last and first day of the month as my reminder.

[RuralGuy]

I would suggest two elements be added to your application. A system table for keeping track of these types of things (a date field would be appropriate here) and a system form that is opened by your AutoExec macro as *hidden*. This form will be the housekeeping form that is the first form to open and the last form to close when exiting the application.

[Microsoft Access Database]

Within the autoexec macro you can set an action to run code. That code would do the date check and display the message.

[MAF4Fam6]

I need a macro msgbox to run automatically on the last day and first day of the month. I have been researching this and cannot find anything on it. Please any help is appreciated.

In the attached Access database (inside zip file), you will find two objects (1 Table/1 Macro).

1. Export the tblSystem table into your database (IMPORTANT: Export BOTH Structure and Data).

2. Then, export the mcrMonthlyMsg Macro into your database.

3. Update the MsgBox MacroActionS per the following screenshot:

Attachment 688

4. Last step: Add the mcrMonthlyMsg Macro to your Startup Form's OnLoad event.

Your message will display ONLY once a month, on the last day or first day of the month, no matter how many times you access the Startup Form.

-RC

[bishop]

In the attached Access database (inside zip file), you will find two objects (1 Table/1 Macro).

1. Export the tblSystem table into your database (IMPORTANT: Export BOTH Structure and Data).

2. Then, export the mcrMonthlyMsg Macro into your database.

3. Update the MsgBox MacroActionS per the following screenshot:

Attachment 688

4. Last step: Add the mcrMonthlyMsg Macro to your Startup Form's OnLoad event.

Your message will display ONLY once a month, on the last day or first day of the month, no matter how many times you access the Startup Form.

-RC

Thank you!!!

[MAF4Fam6]

It's no problem at all.
Glad we could help.
If your issue is resolved please mark your thread as Solved.
Thanks.

-RC