Hi everyone, I can create some o

[yippiekyyay]

Hi everyone,

I can create some objects such as textboxes at runtime thanks to this thread - thread222-687700

But I was wondering if the same could be done for an adodc control? Why is it that the following will not work?
Dim Adodc1 As Adodc
Set Adodc1 = Form1.Controls.Add("Adodc", "Adodc1&quot
Adodc1.Visible = True
Adodc1.Left = 50
Adodc1.Top = 50

I appreciate any advice (related to this question)!

-Sean

 

[vbrocks]

The type has to be either defined by you, or referenced to the correct library using references.

 

[CCLINT]

Use:

MSAdodcLib.Adodc

instead of just
Adodc

 

[yippiekyyay]

Thanks everyone - adding MSAdodcLib as a prefix worked perfectly! I don't know how you guys know this though!?! The intellisense (sp?) kicks in after you type in your first dot operator - but it's the starting point that I still seem to struggle with.

Thanks again!

-Sean

 

[CCLINT]

The intellsense also shows the parent library.

Get in the habit of always using full identifiers.
This way you avoid problems later when another object uses the same name at the same level.

The best way to identify the parent component is to use the Object browser. When you select an item, at the bottom of the window you will see the parent library/object the selected item belongs to. Click on this to see if it also has a parent.

 

[yippiekyyay]

Thanks CCLINT - I can tell that this will help alot!

Cheers!
-Sean