[AccessD] A Matter of Killing

Dear List:

I am exporting a bill of materials to a spreadsheet from an access database.
The file name on the spreadsheet is the part number the user selects plus
some other stuff.

Before I create it I issue a Kill:

Kill gstrBackEndPath & Forms!frmBFGExportBOM!txtAssemblyPartNumber & " - BOM
Export.XLS"

If the file is not there it generates an error of course, file not found.

Is there anything wrong with the simple workaround:

On Error Resume Next
Kill gstrBackEndPath & Forms!frmBFGExportBOM!txtAssemblyPartNumber & " - BOM
Export.XLS"
On Error GoTo 0


MTIA,

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/>