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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Medardo
    New Member
    • Dec 2010
    • 1

    #1

    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...
  • Guido Geurs
    Recognized Expert Contributor
    • Oct 2009
    • 767

    #2
    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

    Working...