Create Set Value Macro for Yes/No Field

M

Melissa

I have a table (tblRecruits) with a yes/no field named
ClubTeamUpdated. I need to do 2 things:

1. Create a macro that when run sets the value of
ClubTeamUpdated for all records to NO.

2. This macro will be run by the user. So I would like to
add it to the switchboard. That is simple. However, could
I automate the macro to run on October 15th of each year
with no user involvement? If yes to that, could a
notification be sent to the user that the macro ran?
Please be as specific as you can as I am a rookie with
macros.

Thanks in advance for your help.
 

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

Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Want to have macro execute automatically when doc created 3
WORD VBA Search and switch to advanced ... 1
Date Time decimal value help please 1
Need VBA Macro to Loop through pages and print counter in footer of each page 9
macros with a macro 1

Top