Export form and subform controls to Word

Discussion in 'Access Forms Coding' started by snowman, Apr 19, 2006.

  1. snowman

    snowman Guest

    Hi guys

    ive been searching for a while now on various forums and groups and havent
    yet found an answer to my question...

    I need to export the details of a form (and subform) to Word. Basically, the
    form and subform are data entry forms, and I neeed to be able to export the
    information as entered by the user to a Word template. this info will be
    exported before the record is added to the db..

    can somebody please help me with this? my understanding is that this must be
    done via VBA code - can anyone give me some basic pointers (or previous
    examples) of how to do this please?

    snowman, Apr 19, 2006
    1. Advertisements

  2. snowman

    snowman Guest

    also, none of the information will be exported to tables, etc. it is simply
    sending the information entered by the user in the access form to a word

    snowman, Apr 19, 2006
    1. Advertisements

  3. snowman

    Dennis Guest

    This is a very broad issue. there are multiple ways to do what you want.

    The easiest is simply to generate a report, and then save it as an RTF file.
    RTF (rich text format) is readable by Word (except for graphics on the

    If you specifically want to "fill in the blanks" in a Word document, you'll
    need a mail-merge Word doc with a data-source. You then export your data to a
    custom-built table you create, which will function as the data-source for the
    Word doc.

    After that, it's a simple matter of moving data around....
    Dennis, Apr 19, 2006
  4. snowman

    snowman Guest


    I am after a 'fill in the blanks' type document, as the user needs to be able
    to type in additional information on the basis of what has been entered into
    the Access form (and exported to the word doc).

    you say 'export the data to a custom built table' -can you be more specific
    with this? if this means that i need to create another table in Access to
    which the form and subform writes to, then im a bit confused - wouldn't this
    just lead to data duplication?

    I have details on creating a Word template with bookmarks - im at a loss with
    how to complete this end in Access...

    snowman, Apr 19, 2006
  5. snowman

    Dennis Guest

    Read up on Mail-Merge docs in Word. Once you understand that, it becomes
    clear. Technically, you do NOT have to create a new table. You can use the
    existing one. However, if the data you need comes from several sources, it's
    handier to programmatically create a stand-alone table in Access, and
    populate it with the data from your extract/query.

    This table then becomes the "data source" for the mail-merge document.

    Again, you need to understand how that works in Word before you attempt it.
    But really, once you understand the idea, creating a data-source table
    programattically takes about 30 minutes to learn.

    Hope this helps a little.

    Dennis, Apr 20, 2006
  6. snowman

    norbi Guest

    snowman wrote on 04/19/2006 14:08 ET
    Well, there is a way how to export form and subform data to Word

    It is a 2 step process

    Export form with subform's data to Excel
    You will need to use 'A2EE.mda' Access add-in for this part
    This is an add-in that can export data from form with subform, all at once t
    Excel, while keeping the original Access-like drill-down structure
    You will dowonload the add-in and find more details about it on

    Once you get parent-child (form-subform) structured output into the Excel, yo
    can now export it from Excel into any other file formats, including Word

    You can also find an example of such Access to Word export on the abov
    mentioned link

    It only doesn't meet your request that "info will be exported before th
    record is added to the db..
    Still it is the closest to what you look for

    norbi, Jun 12, 2012
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.