Error Message in Macro?

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

(Access 2000) I have a macro, with "transferspreadsheet" action and "File
type" of: ="A:\" & [Forms]![ExportToFloppyA]![FileName] & ".xls" which
copies files to the floppy A disk. I would like an error message pop up
stating; "Please Insert Floppy Disk" when a floppy disk is not inserted in
the drive. Thanks... Randy
 
Macros don't give you much (if any) flexibility in terms of error trapping.

If you switch to using VBA, though, you should be able to trap the error and
prompt, as desired.
 
Back
Top