John W. Colby
jcolby at ColbyConsulting.com
Sat Apr 12 19:06:10 CDT 2003
I am trying to trap the error for docmd.TransferSpreadsheet. If I do SetWarnings false, then Err is never set, even in cases where some or all records fail to import. If I do SetWarnings True, then the typical ugly JET error is displayed when the docmd is executed, and then the err is set and can be interpreted for a more user friendly message, but the ugly message can't be disabled. Does anyone know how to use transferspreadsheet, disable the ugly error message, yet get the err object to set so that I can put up a user friendly message? John W. Colby Colby Consulting www.ColbyConsulting.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com