How can I add some ActiveX Data Control to VBA project

[jd2001]

I am trying to creating an ADO recordset and display all the records into a Datagrid control. I can't find the Datagrid under the VBA Editor.

How can I add the missing data controls to the reference list.

Thanks,
jd

[Killer42]

I am trying to creating an ADO recordset and display all the records into a Datagrid control. I can't find the Datagrid under the VBA Editor.
How can I add the missing data controls to the reference list.
Thanks,
jd

It's usually just a matter of bringing up the References or Components list and ticking the ones you want to use. In VBA, I believe this would be under Tools|References. If you're looking under "D" for "Datagrid", try scrolling down to "Microsoft Datagrid" or similar.

[jd2001]

I checked the Reference under the Tool menu, but there are lots of common controls missing. Is there anywhere I can add them in?

[missinglinq]

InVB Editor Tools->References are the listing of libraries, not ActiveX Controls! Open the appropriate form in Design View, and then go up to
Insert->ActiveX Control and scroll thru the controls. One caveat: some controls are simply listed by their names, while others, like the Datagrid control, is prefixed by the Maker's name. Thus Datagrid won't be in the D's, but rather in the M's. Microsoft Datagrid Control.

[NeoPa]

Nice answer again MissingLinq.
I look forward with anticipation to your imminent 'promotion' (Member is after 30 posts).
I'd like to comment that, as far as I've seen, your posts have all been of a high calibre.
An emphatic welcome from me :)