[AccessD] TransferSpreadsheet error message

OK, that wasn't helpful
Maybe you could do something with this

How to Create a Jet CHECK Constraint
http://support.microsoft.com:80/support/kb/articles/Q201/8/88.ASP

Michael R. Mattys
www.mattysconsulting.com

----- Original Message -----
From: "Michael R Mattys" <michael.mattys at adelphia.net>
To: <accessd at databaseadvisors.com>
Sent: Saturday, April 12, 2003 8:49 PM
Subject: Re: [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
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>