ES-Components
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-Troubl e\OrdersIn TroubleFin al.xlsx
Auto Start - No
Template File - -----------------------
Encoding - -------------------------- --
Output Quality - Print
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-Troubl
Auto Start - No
Template File - -----------------------
Encoding - --------------------------
Output Quality - Print
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See if this will assist you.That's EXACTLY what I suggested ...
Sorry about that Scott.
Need-Access-macro-to-auto-