[AccessD] File Copy

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vamsgBadFileNameOrNumber.asp

William Hindman

----- Original Message ----- 
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Thursday, August 31, 2006 7:46 PM
Subject: [AccessD] File Copy


> Dear List:
>
> When I run a chunk of code which includes:
>
> FileCopy "Cressona Template.xls", Me.txtOutputFileName
>
> it runs fine. If I run it again, however, without closing the form and
> reopening it (but deleting the target file specified in
> Me.txtOutputFileName that was created the first time),  I get an error
> 52 - bad file number.
>
> Does anyone know why?
>
> MTIA,
>
> Rocky
>
> -- 
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>