Partial File Transfer

[Guest]

I am using a form (with a command button) to allows users to backup (transfer) different file formats (.xls, .txt, .mdb, etc) to different mediums (disk, dir, etc). The file copy runs into trouble (like the diskette being full), although an error message is place in the log (another form), the partial file is left on the disk (or dir). Unless the user requests to view the log, he/she will be unaware that the file her/she just copied is incomplete

How can I via VBA code delete the partial file from disk (or where ever transferred) when this error occurs? I can post thecode, if that would help. Thanks

 

[solex]

Use the Kill statement to delete the partial file from disk.

I am using a form (with a command button) to allows users to backup

(transfer) different file formats (.xls, .txt, .mdb, etc) to different
mediums (disk, dir, etc). The file copy runs into trouble (like the
diskette being full), although an error message is place in the log (another
form), the partial file is left on the disk (or dir). Unless the user
requests to view the log, he/she will be unaware that the file her/she just
copied is incomplete.

How can I via VBA code delete the partial file from disk (or where ever

transferred) when this error occurs? I can post thecode, if that would
help. Thanks!

 

[Guest]

I searched Access 2000 Help and there is no Kill Statement listed. Is this the correct name?

 

[solex]

Yes it is the correct name. Just type is in the VBA code editor and the
intellisense will prove that it exists.

Regards,
Dan

I searched Access 2000 Help and there is no Kill Statement listed. Is

this the correct name?