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
    #1 kjellevik, Sep 28, 2010
    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
    176
    30
    #2 Matrix Leader, Sep 28, 2010
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Anakunda

    Anakunda MDL Senior Member

    Feb 6, 2010
    283
    12
    10
    #3 Anakunda, Sep 28, 2010
    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
    9,039
    3,388
    300
    #4 urie, Sep 28, 2010
  5. Matrix Leader

    Matrix Leader MDL Addicted

    Dec 8, 2009
    857
    176
    30
    #5 Matrix Leader, Sep 28, 2010
    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
    365
    3,230
    10
    #6 jlgager, Oct 1, 2010
    please move thread to office forum. Thanks!
     
  7. urie

    urie Moderator
    Staff Member

    May 21, 2007
    9,039
    3,388
    300
    #7 urie, Oct 1, 2010
    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.