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!