How To Create, Manage, and Print Documents with Microsoft Access. Scan or Select from a Combo Box.

How To Create, Manage, and Print Documents with Microsoft Access. Scan or Select from a Combo Box.
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.
Silver Members and up get access to an Extended Cut of this video. Members will see how to print Word Documents, PDFs, and pretty much any other type of external file using my PrintFile function.
MEMBERS VIDEO:
• Create, Manage, and Pr...
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
599cd.com/Prin...
LINKS:
Intro VBA: 599cd.com/Intr...
Barcode Scanning: 599cd.com/Barcode
Barcode Seminar: 599cd.com/Barc...
Report Listbox: 599cd.com/Repo...
Dymo Labels: 599cd.com/Dymo...
Access Expert 6: 599cd.com/ACX6
Open Report Specific: 599cd.com/Open...
Images: 599cd.com/Images
Open Other Programs Seminar: 599cd.com/ACOpen
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Paid TechHelp Questions: 599cd.com/Tech...
Consulting Help: 599cd.com/Cons...
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@robertodc62]

men tons of info thanks i reaured much things i learn by my self and i learn new stuff you are the greatest in access in the world i love your videos but i need much more time to see it i start with the VBA i always use macros but i want more control on mi sistems so i wll the VBa start videos i will tray to become a member cuz you stuff is great

[@599CD]

Glad to help

[@messageofislam958]

Dear Sir, Can I navigate through multiple tables using only one form? {Requirement is to create an audit form for different excel reports of machines. I do not want to design a form for each table separately} Is there a short way to do this?

[@KeffelewAssefa]

Thank you

[@599CD]

You're welcome

[@MohEE-rw6sx]

Nice! ur efforts r the best!

[@599CD]

Thanks

[@MishaGreer]

Hey Richard from Alabama! Why not use mail merge documents?

[@599CD]

Who's from Alabama? You? I'm in Florida. :) Why use Mail Merge when you can do the whole thing in Access?

[@wesmoore6956]

Hello, I know this video is about a year old now - at 30:40 you mention overlaying text fields on an existing form as an image in a report. This is exactly what I am trying to do. I find that merely including a text box on the report in design view where it LOOKS like it should go produces highly inaccurate results once you switch to print preview mode (usually resulting in overlays being quite out of alignment). I have to more or less trial-and-error the positioning of these controls, clicking back and forth between design view and print preview. For people like me trying to hack something together like this, do you have perhaps a follow-up video that goes more in depth? And maybe also covers improved print quality of the underlying form having been converted to an image I'm using in the background? As it looks quite low quality. Thank you in advance!

[@599CD]

599cd.com/FixPoorQualityImages

[@angrypatriot1907]

Rich, do you teach VB using Visual Studio?

[@599CD]

I have nothing at the moment. I have some older VB6 lessons, but they're like 20 years old. I plan to do some VB lessons hopefully later this year.

[@TheSmartMover]

Do you have any videos that explains how to allow an employee to save a pdf to a customer file.

[@599CD]

You just print preview the report and then save it as a PDF file. I cover that in my very first Access Beginner 1 class: 599cd.com/ACB1

[@rumanaparveen9755]

dear sir, is it possible to draw any type of shape automatically in ms access. I mean that, i put several value and automatically drawn a shape on basis of my inputed value

[@599CD]

You can draw lines and rectangles... so I guess if you want to do the math and draw other polygons and circles using lines, it's possible... but I don't recommend it. Access isn't really a graphics program.

[@rumanaparveen9755]

@@599CD Thanks sir

[@mtsmultan]

Hello , pleae help we want to distribute .accdb file only for 1 pc license , how can we restrict for install this file to another pc , kindly suggest code or some other method

[@599CD]

599cd.com/Registration

[@vincentchikobe6789]

Sir can you help I need to know how I can create a print preview dialog in access

[@599CD]

599cd.com/ask