Create, Print Documents from Microsoft Access

In this video, I'll show you how to create documents in Microsoft Access. I don't just mean Access-generated reports. I'm also including documents that are based on existing printed forms you may have. You'll see how to select a document from a list in a combo box (or scan in a barcode) and have the document print to your default printer or preview on the screen. We'll also see how to populate these documents with data from your tables.

Windle from Williamsburg, Virginia (a Developer student) asks: I took your Barcode Seminar. Is there a way to scan a barcode and have Access print a specific document? I manage a pharmacy and would love to place a barcode on medication bottles that triggers the printing of patient educational materials when scanned.

Members

Members will see how to print Word Documents, PDFs, and pretty much any other type of external file using my PrintFile function. 

•  Extended Cut Video - Silver
•  Gold Member Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

• Intro VBA: https://599cd.com/IntroVBA
• Barcode Scanning: https://599cd.com/Barcode
• Barcode Seminar: https://599cd.com/BarcodeSeminar
• Report Listbox: https://599cd.com/ReportListbox
• Dymo Labels: https://599cd.com/DymoLabels
• Access Expert 6: https://599cd.com/ACX6
• Open Report Specific: https://599cd.com/OpenReportSpecific
• Images: https://599cd.com/Images
• Open Other Programs Seminar: https://599cd.com/ACOpen

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, existing forms, existing paperwork, paper forms, based on current forms, print word documents from access vba, access word docs, access print word, print pdf from vba, insurance forms, shellexec, drug facts label, look like existing document, shellexec, D&D character sheet, dungeons & dragons character sheet