Small Problem

D

David B

Hi there. I am currently running a batch file that opens
Access 2000 and runs a macro that saves one of the reports
as a snapshot. Each time the batch file runs, it displays
the message 'File exists. Do you wish to replace.' I
always want it to replace. Does anyone know how to turn
of that message. I tryed SetWarning = No but that
automatically presses the 'No' on overwriting the file.
Hope someone can help.
 
M

May

Try it this way without involving any code
Tools --> Options --> Edit/Find --> uncheck "document
deletion"

May
MCP in Access and SQL Server
 

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

Top