[AccessD] A Matter of Killing

I do that all the time ~Rocky.

But normally, on error goto errhandler after the kill code - same thing
though.



Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: 16 August 2009 14:57
To: 'Access Developers discussion and problem solving'
Subject: [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/>