Macro to delete and then append

[bb_]

How can I create a Macro that will empty a table and then run a query that appends records to the same table?

[pbaldy]

I would use VBA, but you can use RunQuery to run a delete query and then an append query.

[bb_]

if i use VBA do i have to add it to a button to a form for it to execute?

[June7]

How did you plan to run a macro - just by clicking it in the Navigation Pane?

VBA procedures in a general module can be run from the VBA editor with the Run button.

Are you building a multi-user db or is this just for you alone?

[pbaldy]

I'll get out of the way.

[bb_]

multiuser- trying to make it easy for a colleague to update a linked list in sharepoint monthly. would like it to be a one click

[June7]

Then regardless if you use macro or VBA, should be a form for user interface.