Results 1 to 4 of 4
  1. #1
    Join Date
    May 2014
    Location
    Houston
    Posts
    3

    Want to create form button to create Word document

    My office uses dozens of reports with fields that we manually update each time we use them (daily). Archaic, I know. I know how to link Word document fields back to an access table, but I'd rather have the users enter their data into an Access 2013 form and then push a button (or the like) that will create the word document (with dialogue that is pre-prepared). I don't want them having to open word and initiate a merge.

    Am I clear enough? I have the data, the report and the document, but nothing flows yet. I'm fairly fluent in Access 2013, but in no way a pro. So layman's terms will be appreciated.

    Many thanks!



    Lisa
    Business Analyst

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Access can do this internally with a single line using the built-in reports.
    DoCmd.OpenReport "rReport", acViewPreview ,,"[ClientID]=" & vID

    Wont this work for you?

  3. #3
    Join Date
    May 2014
    Location
    Houston
    Posts
    3
    Thanks RanMan! I'll try that.

  4. #4
    Join Date
    May 2014
    Location
    Houston
    Posts
    3
    I forgot to mention that these reports contain static dialogue with fields that need to be updated via the form "execution button". Much like a mail merge, but many more fields. How do I set up the standard report for the fields to update to. Just type it into a blank report?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-20-2013, 01:45 PM
  2. Replies: 3
    Last Post: 03-23-2013, 03:13 PM
  3. Create Database from Word Document
    By jwtasu in forum Import/Export Data
    Replies: 4
    Last Post: 06-15-2012, 02:12 AM
  4. Create new Word document.
    By Bill H in forum Programming
    Replies: 3
    Last Post: 06-12-2012, 06:40 AM
  5. Create an RDP link button on my form
    By BDP in forum Access
    Replies: 1
    Last Post: 09-14-2010, 02:49 PM

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
  •  
Other Forums: Microsoft Office Forums