Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

News      User Comments     History     Notify Me

10/3/2008 4:18:36 AM
Access Inventory Courses
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

I just finished some new Advanced Microsoft Access courses dealing with Recordsets and Inventory Control.

Basically, a Recordset allows you to edit, add, or delete data from your tables using VBA code. In order to do anything advanced with your data, you have to know Recordsets.

One of the most requested topics is "how do I manage my inventory?" If a customer orders some products and you ship them out, you need to take those items out of your inventory, keep track of reorder levels, and of course order those items from a vendor. That's inventory control.

I've recorded TEN new courses (Access 320 thru 329) that have to deal primarily with Recordsets - although there's a lot of additional material in there too like programming multi-select listboxes, triple-state checkboxes, adding an option to a combo box on the fly (OnNotInList) and lots, LOTS more.


Recordset Basics
What is a Recordset?
Microsoft DAO 3.6 Object Library
Moving Around in Recordsets
EOF End of File
RecordCount Property
Finding Records
Wildcard Search
Do Loop


Open Recordset with SQL
Adding Items to a ListBox
Editing Recordsets
Editing One Record
Editing Multiple Records
Multi-Select List Boxes
Adding & Deleting Records


Record Locking Options
Seek Method
Recordset to a Different Database
Reading One Value From Multi-Select Box
Reading Records From A Different Database
Fields Collection
Create a Logon form
Recordset to Check Password
Logging User Activity


ADO ActiveX Data Objects
Recordset Types
Loop Through Records (EOF)
Editing Records
AddNew to Add a New Record
Delete to Delete a Record
ADO Connection Strings
Connect to SQL Server
Student Test Taker Project
Nz Function To Return Zero on Null


Calculating Loan Amortizations
Calculate Monthly Payment
Using the PMT Function
Use a RecordSet to Create Payment Schedule
RecordSet to Add Manual Payments
Fixing the Missing Penny Fraction
On Not In List Event
Adding a New Value to a Combo Box
Limit To List Property
NotInList Event


Synchronizing Two Tables
Detecting Changed Records
Importing Changes
Detecting New Records
Tracking Student Attendence Project
Tables to Track Students & Days Absent
Multi-Select Listbox to Pick Students
Recordset to Add Absent Days
Table to Track Days Off (Holidays, etc.)
Aggregate Query to Count Absent Days


Lock the Order if it's Paid
Refunding an Order
Can't Refund a Shipped Order
Inventory Levels
Quantity On Hand
Tracking which employee changed inventory level
Increment Quantity if item already on order
Shipping The Order
OKToShip Function
Check to see if we have enough inventory on hand


Create a Packing Slip
Processing Cancelled Shipments
Adding Inventory
Shipping Orders With Products Not In Database
Shipping Methods
Create Shipping Form
Tracking On The Web
Figuring Out UPS Tracking Links
Automatically Launching your Web Browser


Reorder Levels
Vendor Information
Query to show Products Understocked
Purchase Order Table
Make a Purchase Order
Creating a PO with a Recordset
Check if this item is already on a PO
Check Box to Filter Open/Closed POs
Tri-State CheckBoxes (Triple State)


Inventory Control Part 4
Purchase Order Report
Receive Parts
Closing POs
Bulk Email From Access w Outlook

Permanent Link
Keywords: access inventory barcode scanner recordset
Post Reply

Access Inventory Courses Comment from Joseph R @ 9/30/2015
I see returning items from the vendor but I do not see after the parts are received that they are automatically adjusted in the QtyOnHand in the inventory.  Also It would be awesome if this was added plus dealing with partical orders, returns, etc.

Reply from Alex Hedley:

I think this is covered in later lessons when we get to VBA programming.
Show Just This Thread        Post Reply
Barcode Scanner Comment from Richard Rost @ 9/24/2009
I've added "Using Access with a Barcode Scanner" to the WAITING LIST under the "Other New Seminars" section. If you're interested in seeing how to do this, VOTE for this seminar on the Waiting List. If I get 4 or 5 people who are interested, I'll record the seminar.
Show Just This Thread        Post Reply
Access Inventory Classes Comment from Richard Rost @ 10/3/2008
Colin, we already have a discount percentage that you can put on each customer account. Do you need something more than that? As far as "terms discount for early settlement" do you mean something like 2%NET10 terms (where they get a 2% discount for paying in 10 days)?
Show Just This Thread        Post Reply
New Courses Comment from Alan Hill @ 10/3/2008
Exactly what I need. With the knowledge gained from these courses I will be able to say I now know Access.
Thankyou Richard. It's been worth the wait.
Show Just This Thread        Post Reply
Access Inventory Classes Comment from Colin Scamp @ 10/3/2008
Another couple of ideas.
Discount structure for customers, terms discount for early settlement?
Regards Colin
Show Just This Thread        Post Reply
Access Inventory Classes Comment from Colin Scamp @ 10/3/2008
They look great, just what I've been waiting for! Another idea, what about issuing credit notes for invoiced/returned to stock items, faulty items? Re-entering the items back to stock. Cancelling Back orders.
Regards Colinby customer?
Show Just This Thread        Post Reply

Add Your Comments or Subscribe
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
  Your Name:  Required
  Your Email:  NOT Public


Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 8+3:
  Notify me when the News is updated.
  Remember Me for my next comments
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard



You may want to read these articles from the 599CD News:

8/15/2019Last Chance for Access CDs
8/1/2019Customer List Form Template
8/1/2019New Template Access Customer Database
7/30/2019Microsoft Access Developer 13
6/20/2019TIP: Validation Rules in Access
11/20/2018Microsoft Access Developer 12
8/25/2018NEW: Access Dev 9, 10, 11
8/25/2018Microsoft Access Developer 11
8/25/2018Microsoft Access Developer 10
8/25/2018Microsoft Access Developer 9

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP