Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2011
    Posts
    8

    Question Unanswered: export form to excel file

    Hi Guys,

    I am developing an Access application that requires user signature before accepting input to the tables.

    What happens is: when a client comes in and place a (share trading) order, I will open an Access form, and fill in client’s details (in main form) and details of a number of transactions orders ( in sub form). Before saving these inputs to the tables, I wish to press a button to “export” or write them into specific cells in an Excel file (in a format I've already created), then print it out for client to sign.

    I am pretty familiar with VBA in Excel but totally clueless in Access. Any help with this is much appreciated !

    Cheers,
    TeeDee

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Link to the Excel spreadsheet in Access (see DoCmd.TransferSpreadsheet in the Access help file for details). When you hit the final approval button, have VBA open the linked file and add the record into it.

    Make sure the Excel file is closed before hitting the approval button in the Access form. The Excel file sometimes gets screwed up when that happens.

    This assumes that you're using a different table for the RecordSource of the Access form (that's how I understand your description). If that isn't the case, you can use the linked table as the RecordSource.

    Sam

  3. #3
    Join Date
    Jun 2011
    Posts
    8
    Thanks Sam ! It works !

  4. #4
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Great! I'm happy for you.

    You're welcome,

    Sam

Tags for this Thread

Posting Permissions

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