Where is ADO Data Control???

[Guest]

Hi! I already add Microsoft ActiveX Data Objects 2.5 Library in VBE using
TOOLS>REFERENCES but I still cannot find the ado data control in the
toolbox..By the way I'm using Excel 2002. I hope you'll help me..

 

[NickHK]

Adding a reference gives you access to the Type Library for early binding,
essentially using ADO in code with no visible control.
If you want the control, right-click on the Controls Toolbox, select
Additional Controls and put a check mark against the desired component.

Having said that, I have always preferred the coded version to the data
control for flexibility.

NickHK

 

[Guest]

what do you mean coded version? How do i start with it? Sorry. I'm just new
to ADO. thank You!

 

[NickHK]

As I said, setting a reference does NOT give the visible control to use on a
userform, but it allows you create the early-bound ADO objects. e.g.
Dim ADORS As ADODB.Recordset
'..etc

You should read up on using ADO if this means nothing to you.
http://support.microsoft.com/kb/257819

Otherwise, add the control to the Toolbox as I explained and use that
instead.

NickHK

 

[Guest]

Thanks nick!

As I said, setting a reference does NOT give the visible control to use on a
userform, but it allows you create the early-bound ADO objects. e.g.
Dim ADORS As ADODB.Recordset
'..etc

You should read up on using ADO if this means nothing to you.
http://support.microsoft.com/kb/257819

Otherwise, add the control to the Toolbox as I explained and use that
instead.

NickHK