Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Developer > D27 > < D26 | D28 >
Access Developer 27

Barcode Scanning & Printing, Inventory Control

 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Buy Now


In this class, we're doing some more work with managing inventory. If you want to scan or print barcodes for your databases, then there is some great material here. Even if you don't plan to use barcodes, there's lots of stuff that I haven't covered before, like the new WebBrowser control and downloading files from the Web. Watch the beginning of Lesson 1 for details.

We're doing more work with recordsets. We'll be managing individual units instead of just products. So you can print out barcodes for each unit (track a unique serial number for each one). We'll cover scanning those items in and out of inventory. We'll learn how to recognize what type of code was scanned (part number or serial number).


Topics Covered

In Lesson 1, we'll discuss the types of barcode scanners, the different types of barcodes, 1D and 2D barcode symbologies, using your cell phone as a barcode reader, creating a product table with a barcode field, creating a form to scan a barcode and look up a product.

In Lesson 2, we'll learn how to scan a product and have it automatically added to an invoice. We'll also check to see if the product is already on the order, and if so, increment the value by one instead of adding lots of line items. We will also learn how to scan a product and perform a Google search on it to display details. Great for books or any product with a UPC barcode.

In Lesson 3, we'll learn how to print barcode labels. We'll talk about the Code39 barcode and why I prefer it for Access databases. I'll show you how to install a FREE Code39 barcode font. Then we'll see how to create custom barcode labels for our products and print them out from Access. 

In Lesson 4, we'll learn how to print multiple labels for the same product, so if you want to print out 10 copies of the same label, it's easy to do. We'll create a button on our Product Form to create individual labels, and then a button to clear the table once we've printed.

In Lesson 5, we'll learn how to use the Google Charts API and the WebBrowser Control to display QR Codes (2D barcodes) in your forms. QR Codes are great for detailed product info, employee name badges, whole web page URLs, or any time you want to display an image for someone to scan with their phone to get detailed information.

In Lesson 6, we'll learn how to download the QR code from the web and save it as a local file on our hard drive, in a folder under the current database folder. Then, you will see how to display that file as an image in a report so we can print employee name badges.

In Lesson 7, we'll merge the barcode "stuff" into our Developer database. We'll copy the scan box, create a product list form, I'll show you how to synchronize two open forms, we'll create a product form, and we'll make a product barcode lookup box for scanning. 

In Lesson 8, we'll create a method to manually adjust inventory. This is useful when you receive product shipments from your vendors. Just scan the items in. We'll create a combo box where we can select either a lookup scan, remove from inventory, or add to inventory action. We'll change the quantity on hand of the product scanned. We'll include logic to prevent negative inventory.

In Lesson 9, we'll add tracking individual unit serial numbers. We'll create a unit table and form as a subform under the product form. This way you can track each of the 200 individual photon torpedoes you have in stock, what their serial numbers are, and to which Klingon you sold them to on the Orion black market. We'll create a barcode report for serial number labels, and a button to mark them printed when finished. 

In Lesson 10, we'll add the ability to scan barcodes from products or serial numbers to our order form. If it's a serial number then we cannot increment the quantity, we have to add a new line item with the unique barcode. We'll check to see if this unit is already on another order and generate a warning if so. We'll put barcodes on the printed invoices.

In Lesson 11, we'll add the printed barcode labels from the products that we designed earlier. We'll add the ability to print as many labels as we want in a loop, and mark the labels printed when we're done.

Enroll Today

Enroll now so that you can watch these lessons, learn with us, post questions, and more.


Please feel free to post your questions or comments below. If you are not sure as to whether or not this product will meet your needs, I'd rather help you before you buy it. Remember, all sales are final. Thank you.


Start a NEW Conversation
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
Subscribe to Access Developer 27
Get notifications when this page is updated

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/16/2024 5:28:55 AM. PLT: 1s
Keywords: access developer 27 Barcodes 1D vs 2D Symbologies Product Table Scan Order Increment Quantity Code39 Barcode Font Custom Labels Google Charts API WebBrowser Control QR Codes Forms Download QR Codes Synchronize Forms Manual Inventory Logic Prevent Negative  Page Tag: whatsnew  PermaLink  Microsoft Access Developer 27