How do I know when a class object exists?

[rocco]

Hello,
I need to manage users of a databases trough a class MyUsers. The database
will run on one pc only and users can change during operations. Each user
will have special rights to do something and will be denied to do something
else. Anytime users change i have to create a new user and to destroy the
last one by using the SET to NOTHING thing. Is there any way to know if a
class object exists so that I can set it to nothing? I know I can workaround
with On Error Resume Next, but I'm pretty sure there will be something more
elegant and appropriate.
Thanks.

 

[David C. Holley]

You're probably looking for the Is Nothing keyword.
http://www.everythingaccess.com/tut...n-Nothing,-Empty,-Missing,-Null,-Zero-and-ZLS

 

[Daniel Pineault]

Have you tried something like:

If Obj Is Nothing Then
'Obj does not exist
Else
'Obj does exist
End If

You may wish to read over the info found at
http://www.cpearson.com/excel/Classes.aspx
Even though it is an Excel site, the info is valid for vba, so applicable to
access as well.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[rocco]

no... I haven't tried. Looks to smarts for me!! But thanks !!!!
And thanks for the link, very useful.
rocco

 

[Jack Leach]

And thanks for the link, very useful.

Chip has a wealth of information that can't seem to be found anywhere else.

I've never written a single line of vba in an excel file, this is one of my
favorite tech sites of all time nonetheless. He does an excellent job.

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)