Results 1 to 4 of 4
  1. #1
    Join Date
    May 2009

    Unanswered: Edit Record In Access from Excel Using VBA

    I want to edit an existing record in an Access table using VBA from Excel.

    The table in access has a primary key.
    A cell in Excel will has the numerical key.

    So I need the VBA to connect to my Access table.
    Locate the correct record by looking at an Excel cell.
    Update specific fields in that record.

    Seems pretty simple but I have spent hours looking for help so I am posting. The problem probably lies in my not understanding ADO and such very well.

    Thanks for your time!
    Last edited by quickoats; 05-28-09 at 12:58.

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Another confused Excel user

    If you want to write VBA in Excel, why are you asking Access gurus? You need to seek Excel gurus, which btw are nowhere near as cool as Access gurus.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    May 2009
    I hang my head in shame and leave the very cool Access guru lounge. I just wanted to fit in!

    Consider this thread closed and I will repost my question here.

  4. #4
    Join Date
    Dec 2004
    Madison, WI
    Now look what you've done ST. You went and scared quickoats off (even though you're right about MSAccess developers being cooler than Excel developers.)
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts