473,396 Members | 1,982 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

How can I add the Datacontrol in my VBA macro app?

I'm writting a program in VBA, to add some advanced Macros to a word document, and I need to read and manipulate some data from an Access database. So I created a form but I can't find the Datacontrol, I found the Datalist, the DBList, the Datalist, but not the Datacontrol. Even when I'm writing code the Database and Recordset types are not recognoised when I'm defining variables. Please help...
Dec 14 '10 #1

✓ answered by Guido Geurs

In the Toolbox - Controls: RMB = "Additional Controls"
Select in the list:
[x] Microsoft ADO Data Control
[x] Microsoft DataCombo
....

These controls are from SP6(OLEDB) and in the files:
C:\Windows\system32\MSAdoDc.ocx
...\MSDatLst.ocx
...\MSDatGrid.ocx
...

Maybe You have to install them first ?

1 2179
Guido Geurs
767 Expert 512MB
In the Toolbox - Controls: RMB = "Additional Controls"
Select in the list:
[x] Microsoft ADO Data Control
[x] Microsoft DataCombo
....

These controls are from SP6(OLEDB) and in the files:
C:\Windows\system32\MSAdoDc.ocx
...\MSDatLst.ocx
...\MSDatGrid.ocx
...

Maybe You have to install them first ?
Dec 15 '10 #2

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

Similar topics

699
by: mike420 | last post by:
I think everyone who used Python will agree that its syntax is the best thing going for it. It is very readable and easy for everyone to learn. But, Python does not a have very good macro...
2
by: Pete | last post by:
In Access 95/97 I used to be able to create pull down menus (File,Edit ...) from a macro. It seems there used to be some wizard for that. However in Access 2000 it seems you have to build your...
7
by: Newbie_sw2003 | last post by:
Where should I use them? I am giving you my understandings. Please correct me if I am wrong: MACRO: e.g.:#define ref-name 99 The code is substituted by the MACRO ref-name. So no overhead....
3
by: Alexander Ulyanov | last post by:
Hi all. Is it possible to pass the whole blocks of code (possibly including " and ,) as macro parameters? I want to do something like: MACRO(FOO, "Foo", "return "Foobar";", "foo();...
0
by: John A Grandy | last post by:
in ASP.NET 2.0 , what is the best WebForm DataControl to bind to a Hashtable ?
1
by: Maruthi Seshidhar | last post by:
The datacontrol available in vb6 toolbox is not available in vb.net toolbox. where can I find it.
1
by: tarscher | last post by:
Hi all, I have a list containing objects. Each object also contains a list of objects. e.g.: A1: B1 - B2 - B3 A2: B1 - B2 - B3 - B4 A3: B1 - B2 - A4: B1 - B2 - B3
0
by: jackvel | last post by:
Hi Dudes... I want to connect the Access database with VB 6.0 without using DataControl and ADODC.. Which option should i use.? Plz send me the detailed procedure of doing the same.. Plz...
4
by: jaz215 | last post by:
hi! how do i add a record in a database without using the datacontrol and adodc. i want to rework my code to using purely codes and not being dependent on the design on vb. so far i have. Set rs...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.