Hi! I already add Microsoft ActiveX Data Objects 2.5 Library in VBE using
TOOLSREFERENCES 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..

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

"Chinx21" . wrote in message
...
Hi! I already add Microsoft ActiveX Data Objects 2.5 Library in VBE using
TOOLSREFERENCES 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..

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

"NickHK" wrote:

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

"Chinx21" . wrote in message
...
Hi! I already add Microsoft ActiveX Data Objects 2.5 Library in VBE using
TOOLSREFERENCES 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..

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

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

"NickHK" wrote:

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

"Chinx21" . wrote in message
...
Hi! I already add Microsoft ActiveX Data Objects 2.5 Library in VBE
using
TOOLSREFERENCES 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..

Thanks nick!

"NickHK" wrote:

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

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

"NickHK" wrote:

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

"Chinx21" . wrote in message
...
Hi! I already add Microsoft ActiveX Data Objects 2.5 Library in VBE
using
TOOLSREFERENCES 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..