[AccessD] A Matter of Killing

Hi Rocky,

Try this: (Aircode)

Dim FileSize As Long
FileSize = FileLen(gstrBackEndPath & 
Forms!frmBFGExportBOM!txtAssemblyPartNumber & " -  BOM")
If FileSize>0 Then
    Kill gstrBackEndPath & Forms!frmBFGExportBOM!txtAssemblyPartNumber & " - 
BOM"
End If

-
Michael R Mattys
MapPoint and Database Dev
www.mattysconsulting.com
-
----- Original Message ----- 
From: "Susan Harkins" <ssharkins at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Sunday, August 16, 2009 10:19 AM
Subject: Re: [AccessD] A Matter of Killing


> Not as far as I'm concerned. I think, if you can route out the error 
> another
> way, you should, but this quick fix is acceptable, especially if the
> alternative is lengthy. I use it occasionally.
>
> Susan H.
>
>
>> Is there anything wrong with the simple workaround:
>>
>> On Error Resume Next
>> Kill gstrBackEndPath & Forms!frmBFGExportBOM!txtAssemblyPartNumber & " -
>> BOM
>> Export.XLS"
>> On Error GoTo 0
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>