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
ES-ComponentsAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can add the SetWarnings = False BEFORE the other macro actions, then add SetWarnings=True AFTER, but in general it's a bad idea to use those things.
0
 
Wayne BarronAuthor, Web DeveloperCommented:
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
See if this will assist you.
That's EXACTLY what I suggested ...
1
 
Wayne BarronAuthor, Web DeveloperCommented:
Sorry about that Scott.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.