Msgbox for overwrite existing file

[rajeevwgs]

When exporting to pdf format in access 2010, i am not receiving the "do you want to overwrite existing file" message. my Code is like this
DoCmd.OutputTo acOutputReport, "LPO", acFormatPDF, "C:\users\touchmate\desktop\lpo.pdf"

Anyone can help...?

 

[pbaldy]

You can use the Dir() function to see if the file exists before exporting.

 

[rajeevwgs]

You can use the Dir() function to see if the file exists before exporting.

Thankyou for your reply, i can see my file because it is in desktop, that's why i posted this, and also when i create export using macro to the same location it is asking for overwrite...and also i convert that macro to vba, at that time that message is not coming....??