error: object variable

[Roy Goldhammer]

Hello there

On many areas at my program i use objects

if the set action failed, the object won't be set

and if i use this object after word i get the error: 91, object variable,
vith block or with block not set.

Is there a way to know on object if it set or not?

 

[DAVID]

Use IsObject to see if a Variant is an Object.

See IsNothing to see if an Object is set or not.

But note that an Object can be set and still
not valid. For example, if you set an object
to be an Excel Application, and then close
the Excel Application, the object is still
an Excel Application object, but not a usable
one:

sub test()
Dim db As DAO.Database
Set db = OpenDatabase(CodeDb.Name)
db.Close
If (db Is Nothing) Then MsgBox "nothing"
MsgBox db.Name
end