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" <(E-Mail Removed).> wrote in message
news:F1BE1858-0153-4D65-9C69-(E-Mail Removed)...
> 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" <(E-Mail Removed).> wrote in message
> > news:EDDC1E6C-0893-4435-AEE2-(E-Mail Removed)...
> > > 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..
> >
> >
> >
Similar Threads
