Error Message in Macro?

[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

 

[Douglas J. Steele]

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.