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

Welcome to the Microsoft Access Forum. Access is by far our most popular topic here at Computer Learning Zone. This forum is for everyone to read but only students (paid customers) can post here. If you'd like to become a student, all you have to do is enroll in one of my courses. After you create a logon, you will have full access to the Forums.

Subscribe to this forum and receive an email update whenever new posts are added. You will also be notified by email if any conversations you are involved in receieve new comments. Yes, even non-students can subscribe to update notifications.

Having problems with your Access database? Before posting your question, check to see if it's already been answered. You can use the Search feature to look for keywords. There's also the Access Troubleshooting Checklist which covers solutions to many common problems. If neither of those things help, make sure you post exactly what you're doing, what the specific error message is, what you've tried, and any other details we might need to help you. Don't just say, "I get an error." Tell us what the error is and what you're doing. We're not mind readers. I wish. LOL

Click Here to Post a comment and start a new discussion


Inventory Control in Access Link 
Jeffrey Bates 
3 months ago
Hi Richard,  Absolutely love your work.  I have purchased up to Advanced 1,  but only got through the lessons to Expert 9 so far.

Do any of your lessons cover the requirements to create an inventory control database.  If so which are they.  My intent is to work through all the lessons but I might like to take a sneak peak.

Best regatds

Richard Rost
3 months ago
Properly handling inventory control isn't easy, which is why I wait until well into the Developer classes to cover it. You really need to know VBA Recordsets first, or at least SQL so you can modify values in table from code. There is a way to do it without programming, but it's kinda sloppy. I may show it as an example in an upcoming TechHelp video, but you really should do it the RIGHT way if you're going to run a business on it.

I haven't covered inventory in my current Developer series yet. It's coming up soon. I just got to Recordsets in Developer 16. In my older Access 2003 lessons, inventory took me 4 classes (Access 326-329) to cover properly. I'll be revising all of these lessons for Access 2019 over the next couple of Developer lessons, so if you want to start learning this stuff now, grab Developer 16 and 17.

I will be including proper inventory control as a module in the ABCD after I build the order entry module, so that's going to be a little while. Hopefully I'll get to it in the next month or two.
Add a Reply

Show All Comments

Post a New Comment or Question
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

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

1/22/2021Reminder Popup Date
1/21/2021Order By, Filter On Load
1/19/2021Reminder Popup
1/18/2021Separate Username in Email
1/16/2021Access Developer 24
1/16/2021Access Developer 24 Lessons
1/16/2021Access Developer 24
1/16/2021Access Developer 23
1/16/2021Last Name, First
1/16/2021TechHelp Free Templates

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
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 The Site
Waiting List
Production Schedule
Code Vault
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Live Chat
General Info
Support Policy
Contact Form
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Keywords: microsoft access forum  PermaLink