Check existence of a control??

[mohsinhq]

hi,

I have an ActiveX control which needs to be registered the first time a user opens the database on a machine.

Is it possible to run a query/autoexec or similar on startup which informs the user if this particular ActiveX control isnt registered?

Our company is undergoing an OS upgrade and it would be useful to inform the user to register the control if not done..

Thanks in Advance

 

[The_Doc_Man]

Unfortunately, this qualifies as a real "catch 22" because the way to test this is with a VBA function, GetSettings (I think that is it; try the Help files).

The reason is that the ActiveX control is available only after you have a reference to the file that holds it, AND you have to register the control. I.e. registry entries.

I have perhaps missed a few posts here and there but I haven't noticed a post showing code that avoids the initial manual check of your references and registered controls. The reason is that your code cannot be compiled if there is a missing reference. Ah, the wonders of MS Office!

 

[mohsinhq]

LOL!

Ive managed to get part of what i want to do working.

Your right with the Catch22.. i can get a module to check whether a control is registered and if it isnt then i can automatically register it.

However, the activeX control has to have been manually set up first using the Tools > ActiveX function!

Would be a very useful additon if i could get it to work!