How do I know when a class object exists?

  • Thread starter Thread starter rocco
  • Start date Start date
R

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.
 
no... I haven't tried. Looks to smarts for me!! But thanks !!!!
And thanks for the link, very useful.
rocco
 
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)
 
Back
Top