Link to home
Start Free TrialLog in
Avatar of ES-Components
ES-ComponentsFlag for United States of America

asked on

In Microsoft Access how to eliminate the prompt: File already exists, do you want to replace the existing file? Yes/No

I am using Access 2016. I am running a Macro that exports a file. I set it up as below.
How do I eliminate the following prompt?   File already exists. Do you want to replace the existing file?  Yes/No

I just want the macro to run automatically each time and replace the existing file WITHOUT the prompt.
I am not a programmer or too familiar with Microsoft Access. If there is a simple solution to this, please let me know and tell me specifically
what I need to do.

Thank you...
Rick

Object Type - Table
Object Name - OrdersInTroubleFinal
Output Format - Excel Worksheet (.xlsx)
Output File - \\Server\my documents\Employee Documents\Rick G Documents\Orders-In-Trouble\OrdersInTroubleFinal.xlsx
Auto Start - No
Template File - -----------------------
Encoding - ----------------------------
Output Quality - Print
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
See if this will assist you.
That's EXACTLY what I suggested ...
Sorry about that Scott.