Matt Pinkston
asked on
Macro Help Access 2010
I have a sharepoint list that I have connected to my access DB.
I need to create a macro that will kick off each day that will update a field "SyncDate" in each record to the current date. By doing this the SharePoint update workflows should kick in doing the individual updates I need from my various lists.
What I need is instructions on how to create a simple macro to update SyncDate in my DB table called table1
Then is there a way to schedule it?
I need to create a macro that will kick off each day that will update a field "SyncDate" in each record to the current date. By doing this the SharePoint update workflows should kick in doing the individual updates I need from my various lists.
What I need is instructions on how to create a simple macro to update SyncDate in my DB table called table1
Then is there a way to schedule it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.