By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

How can I add some ActiveX Data Control to VBA project

P: 4
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
Nov 15 '06 #1
Share this Question
Share on Google+
4 Replies


Expert 5K+
P: 8,434
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.
Nov 15 '06 #2

P: 4
I checked the Reference under the Tool menu, but there are lots of common controls missing. Is there anywhere I can add them in?
Nov 16 '06 #3

missinglinq
Expert 2.5K+
P: 3,532
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.
Nov 16 '06 #4

NeoPa
Expert Mod 15k+
P: 31,487
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 :)
Nov 16 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.