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...
How can I add the Datacontrol in my VBA macro app?
Collapse
X
-
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\syst em32\MSAdoDc.oc x
...\MSDatLst.oc x
...\MSDatGrid.o cx
...
Maybe You have to install them first ?
Comment