[AccessD] TransferSpreadsheet error message

Hi John,

This confirms the problem
Cannot Trap Import Errors ...
http://support.microsoft.com:80/support/kb/articles/Q197/5/96.ASP

Michael R. Mattys
www.mattysconsulting.com

----- Original Message -----
From: "John W. Colby" <jcolby at ColbyConsulting.com>
To: "AccessD" <AccessD at databaseadvisors.com>
Sent: Saturday, April 12, 2003 8:06 PM
Subject: [AccessD] TransferSpreadsheet error message


> 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
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com