Results 1 to 2 of 2
  1. #1
    beewerks is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2014
    Location
    Longmont, Colorado
    Posts
    7

    Filling in fields in Word doc from Access

    Hello everyone, I've got an Access database that collects various calibration data from the products we build and I'm trying to get it automated a bit. We have a calibration sheet for each product that is a Word document and uses numbers from the Access database.I've made each line on the Word document a text form field, and I have a report with all of the data cells I want in Access along with a print button created. What I can't figure out is the VB code I need to make the button send the data I want to the correct Word document fields and then automatically print the Word doc without any user input.
    It's probably pretty simple, but all the scouring of the web and Access instruction books haven't given me any good clues. I'd really appreciate your advice!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,526
    Can you just do a Word mail merge?

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

Similar Threads

  1. Replies: 6
    Last Post: 09-22-2013, 09:52 PM
  2. Print Word doc using Access fields
    By fekrinejat in forum Reports
    Replies: 9
    Last Post: 03-12-2013, 05:53 AM
  3. Replies: 7
    Last Post: 01-22-2013, 09:44 PM
  4. Word 2007 filling the forms
    By thanosgr in forum Forms
    Replies: 1
    Last Post: 06-03-2012, 05:21 PM
  5. Filling in Fields
    By BigCat in forum Access
    Replies: 2
    Last Post: 05-19-2011, 02:02 PM

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