Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Thu Aug 31 20:58:32 CDT 2006
That's what come up with help as well. Covers everything but FileCopy. :( Rocky William Hindman wrote: > 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 >> >> > > > > -- Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com