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?


    thanks
     
    snowman, Apr 19, 2006
    #1
    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
    template.

    thanks
     
    snowman, Apr 19, 2006
    #2
    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
    report).

    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....




    "snowman" wrote:

    > 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?
    >
    >
    > thanks
    >
     
    Dennis, Apr 19, 2006
    #3
  4. snowman

    snowman Guest

    Hey

    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...

    thanks
     
    snowman, Apr 19, 2006
    #4
  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


    "snowman" wrote:

    > Hey
    >
    > 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...
    >
    > thanks
    >
     
    Dennis, Apr 20, 2006
    #5
  6. snowman

    norbi Guest

    snowman wrote on 04/19/2006 14:08 ET
    > Hi guy
    >
    > ive been searching for a while now on various forums and groups and haven
    > yet found an answer to my question..
    >
    > I need to export the details of a form (and subform) to Word. Basically, th
    > form and subform are data entry forms, and I neeed to be able to export th
    > information as entered by the user to a Word template. this info will b
    > exported before the record is added to the db.
    >
    > can somebody please help me with this? my understanding is that this must b
    > done via VBA code - can anyone give me some basic pointers (or previou
    > examples) of how to do this please
    >
    >
    > thank
    >

    Well, there is a way how to export form and subform data to Word

    It is a 2 step process

    1
    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
    http://www.limbersti.cz/A2EE

    2
    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

    B
    Norbert
     
    norbi, Jun 12, 2012
    #6
    1. Advertisements

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.
Similar Threads
  1. Sharon Berg

    Subform: Editing Values in Subform Controls

    Sharon Berg, Nov 6, 2003, in forum: Access Forms Coding
    Replies:
    1
    Views:
    123
  2. titlepusher
    Replies:
    1
    Views:
    176
    Boyd \Hi Tech Coach\ via AccessMonster.com
    Oct 17, 2005
  3. Edward Jones (Eddie)

    Datasheet View subForm and Form View subForm on same Master Form

    Edward Jones (Eddie), Apr 18, 2006, in forum: Access Forms Coding
    Replies:
    5
    Views:
    277
    Duane Hookom
    Apr 20, 2006
  4. Peter Stone

    Referring to controls on the Main Form and another Subform

    Peter Stone, Aug 7, 2006, in forum: Access Forms Coding
    Replies:
    7
    Views:
    112
    strive4peace
    Aug 18, 2006
  5. Replies:
    0
    Views:
    157
  6. Replies:
    1
    Views:
    72
    Anthos
    Nov 10, 2007
  7. Sarah

    Link Subform to subform within another subform

    Sarah, Feb 29, 2008, in forum: Access Forms Coding
    Replies:
    2
    Views:
    165
    Sarah
    Mar 1, 2008
  8. Mr. JYC
    Replies:
    1
    Views:
    107
    Allen Browne
    Sep 27, 2008
Loading...