[AccessD] Object variable or With block variable not set

max.wanadoo at gmail.com max.wanadoo at gmail.com
Fri Sep 28 08:23:49 CDT 2007


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




More information about the AccessD mailing list