Results 1 to 6 of 6
  1. #1
    DAOpsMatt is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jan 2018
    Posts
    11

    Import document to use as report?

    Is there a way to use an existing document in Word as a report template that I can add fields from Access to it?

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    No you can't add Access controls to a Word document. Nor can you add Word form fields to an Access form or report.
    What you can do is populate Word form fields from Access, but I'm pretty sure the only way is via Automation. That may not be for the faint of heart. You could also
    a) replicate the document as an Access report and eliminate the .doc
    b) export Access data in one of a few formats (such as RTF, pdf, xls and a few others).
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    Micron is correct, no can do BUT you can merge with Word. No worries about automation just see Albert Kalllal's Word Main Merge...
    http://www.kallal.ca/msaccess/msaccess.html

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Thanks. I forgot about that.

  5. #5
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    That's why there's more than one of us!

  6. #6
    DAOpsMatt is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jan 2018
    Posts
    11
    That is what I was afraid of. Maybe an option for future. Thank you very much for the additional resources, I will check those out.

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

Similar Threads

  1. Replies: 1
    Last Post: 07-07-2016, 12:41 PM
  2. Replies: 5
    Last Post: 01-23-2014, 09:36 AM
  3. Replies: 4
    Last Post: 06-20-2013, 12:19 PM
  4. Export report to word document
    By jackyoung2012 in forum Reports
    Replies: 1
    Last Post: 03-16-2012, 11:16 AM
  5. Import Word document using VBA
    By degras in forum Import/Export Data
    Replies: 4
    Last Post: 04-12-2011, 02:40 AM

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