Outputto Method: How do I have the system Promt users when overwriting

[okitamura]

I am using Outputto method in Access to output a query to excel spreadsheet by specifying a file name. My question is: "Is there a way for Access Application to Prompt a user when the same file name exists in the directory specified within the Output Method parameter? Right now, it overwrites the file withiout any warning. A code example would be very much appreciated.
Thank you in advance!

 

[PHV]

Take a look at the Dir and MsgBox or InputBox functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[AccessGuruCarl]

Take a look at this site, it has some great source code.

http://www.mvps.org/access

It will usually get you pointed in the right directon.

Here is a link for exactly what you need.

http://www.mvps.org/access/modules/mdl0009.htm

Enjoy...

AccessGuruCarl
Programmers helping programmers
you can't find a better site.