Hi Stuart,

isn't merge replication relevant to SQL Server rather than Access?

With RunCommand you can only use an intrinsic constant that specifies which built-in menu or toolbar command is to be run.

I suppose you've converted the macros into subroutines so you...

As to getting the program to shut-down, I suppose using

Application.Quit after having the macros run should do the job.

I see you set me.timerinterval=0

doesn't that disable the OnTimer event so the check is not carried out the next day?

Hi Mike, do you mean you'd put

pid = "DELETE FROM table" ?