Manipulate Access form controls from VB6 Dll

[masteripper]

Hello to everybody
I have a thought of transferring some of my Access functions/subs to an external Dll
I did some tests but i stumbled on a critical issue
How to manipulate a control's attribute for example .Enabled
I can easily get a reference to a form's controls,count them,get their name but i cannot find any way to "change" them.
Maybe you are thinking why anyone would like to do something like that....
Well the answer is simple ...about 175,000 lines of spagheti code with "duplicate" functions spreaded on around 10+ programs....something u so in one mdb should be copied/replicated to to the other ....too much work.

Thanks in advance

P.S any other handy code i could use i very much welcomed.

[LaVolpe]

With VB6, the trick was to pass the DLL an instance of the VB.Global object & that object contains the forms collection, among other stuff. With that forms collection, one can then access the controls on a specific form

VBA seems to have a similar Global object named: VBA.Global

Worth a shot, here's more info on the technique. Sample cannot be used directly as-is.

[RhinoBull]

If you are thinking of doing this sort of change (major change as I see it) then why not build front end in VB and let it manipulate database?
Whether you choose VB6 or VB2010 isn't relevant but my choice would be VB2010.

[masteripper]

Right now i am thinking this Dll in order to clean up some of the code... i am sure i have to jump to the .NET wagon but my time is way limitted..

[masteripper]

With VB6, the trick was to pass the DLL an instance of the VB.Global object & that object contains the forms collection, among other stuff. With that forms collection, one can then access the controls on a specific form

VBA seems to have a similar Global object named: VBA.Global

Worth a shot, here's more info on the technique. Sample cannot be used directly as-is.

I am admit this is way to "different" ...i can't find the suitable word.
DO you have by any chance a small demo...or what...