Help with Excel/Access

Discussion in 'Microsoft Office' started by kjellevik, Sep 28, 2010.

  1. kjellevik

    kjellevik MDL Novice

    Aug 6, 2010
    1
    0
    0
    Hello

    Is there anyone of you who could help me with the following question:
    I`m trying to write a macro code in excel which subtract data from an Access - database. There must be a MsgBox in Excel where I can choose the elements from the access database.

    Thanks for helping.
     
  2. Matrix Leader

    Matrix Leader MDL Addicted

    Dec 8, 2009
    857
    175
    30
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Anakunda

    Anakunda MDL Senior Member

    Feb 6, 2010
    264
    9
    10
    yea use DAO or ODBC or whatever db interface. Both are impemented in VBA for Office. Custom forms are supported in Excel tooooooo.
     
  4. urie

    urie Moderator
    Staff Member

    May 21, 2007
    8,645
    3,003
    300
    And what forum would this be ? Application Software if i'm not mistaken.
     
  5. Matrix Leader

    Matrix Leader MDL Addicted

    Dec 8, 2009
    857
    175
    30
    this was originally posed in the Windows 7 section.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. jlgager

    jlgager MDL Developer

    Oct 30, 2009
    363
    3,161
    10
    please move thread to office forum. Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. urie

    urie Moderator
    Staff Member

    May 21, 2007
    8,645
    3,003
    300
    Ok but it is not like a mod to move to other section without redirecting it and I did not see it in windows 7 section.