[AccessD] Object variable or With block variable not set

That's interesting. Thanks, Max. I will check my sweet nothings at the end
of the code.

Arthur

On 9/28/07, max.wanadoo at gmail.com <max.wanadoo at gmail.com> wrote:
>
> This *normally* means that you are referencing an object which has not
> been
> SET or that if it has been SET that it has lost its focus and gone out of
> existence.  When I had this error recently, it was because I had Set Rst =
> nothing in the code and then in the exit section tried to set it to
> nothing
> again.  If neither is the case for you, then something else is setting the
> object to nothing.
>
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
> Sent: Friday, September 28, 2007 2:09 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Object variable or With block variable not set
>
> I'm getting this message in running some code in Excel. Everything appears
> to work fine but I get this message at the end of the run. No idea why.
> Any
> suggestions?
>
> TIA,
> Arthur
> --
> 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
>