Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Home > Courses > Access > Developer > D19 > D19 Lessons < D18 Lessons | D20 Lessons >
Access Developer 19 Lessons

Welcome to Microsoft Access Developer 19. Total running time is 2 hours, 24 minutes.

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


Database Files



Please feel free to post your questions or comments below. If you have a questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!


If Then for New Customers Upload Images   Link 
JP von der Borch 
6 months ago
ifThenElse added into code below enables new records (customers) in main form

Private Sub Form_Current()
    ' clear listbox
    Dim X As Long
    Dim db As Database
Richard Rost
6 months ago
Thanks for sharing, JP!
Add a Reply
Spelling Errs Upload Images   Link 
Chris Bezant 
7 months ago
Hello Rick
Following your guidance, I also use the capitalisation method for variable names, but in addition I always compile after entering code to help catch errors.
I don't remember seeing youcompile during lessons.
Richard Rost
7 months ago
That's because I never have errors. LOL. Ha ha. No... I'll compile when I'm DONE with a database, before I release a version to a client, or if I've got unexplained errors that I can't figure out. It is a good idea to compile often. Having "option explicit" pretty much makes sure that you declare all of your variables, and will catch misspellings of field names.
Add a Reply
Referential Integrity Upload Images   Link 
James Gray 
7 months ago
Seems like it would be essential to set up the relationship between Recipes and Products so that you cannot delete a product from the product table if the recipe still exists. That does beg the question of what happens if your recipe changes however.
Richard Rost
7 months ago
Of course. I assume by the time you're at this level you understand the need for referential integrity - as you obviously do. Obi Wan has taught you well. I'm not going to take the time in every lesson to show you all of the stuff I've already taught you. Again. That's a lowly Expert-level concept. LOL. If the recipe changes, then what you require will also change. If someone changes it AFTER you make your shopping list, well, "dem's the breaks, kid."
Add a Reply
D19 File Sizes Upload Images   Link 
Richard Rost 
7 months ago
Well, today I discovered there's a bug in the software that I use to compile my videos: Bandicut. It's a good piece of software, but I recently upgraded to a new version and it's making the videos FIVE TIMES LARGER than they should be. They work, so I didn't catch it right away. I didn't realize there was a problem until I went to upload the final ZIP file that contains all the video files and it's 1.35 GB in size. I've never had one that big. Read More...
Add a Reply
How Many Can I Make Upload Images   Link 
James Gray 
7 months ago
It would be great to see how many of each recipe can be made from the products on hand.  Maybe put it along side the recipe name in the What Can I Make list???
Richard Rost
7 months ago
Excellent idea. I actually had something like that in my notes. I might cover it in D20.
Add a Reply
POS Database Upload Images   Link 
James Gray 
7 months ago
Just a question...Recordsets and the lessons surrounding them seem to be essential to the development of the POS system.  I assume that is still the objective, correct?  It will be nice to see a complete, functioning POS system as I can use those processes to build databases for local merchants.  Thanks.
Richard Rost
7 months ago
Yes, that is why I branched off into the recordsets during the Easy Access POS lessons. I was initially going to try to do it without RS, but it quickly became evident that they would make life SO much easier. I'm going to continue the POS, but as a separate Seminar. From the feedback I received, not everyone is interested in the POS, and I'm going to continue with more new topics in the Developer lessons. Look for the POS to continue soon. I have a couple other projects I need to get finished first.
Add a Reply
Developer 19 Finished Upload Images   Link 
Richard Rost 
7 months ago
Access Developer 19 is now finished. I just posted lessons 3 thru 7. They are still uploading right now, but should be done within the hour.
Michelle Maughan
7 months ago
Thanks Richard
Add a Reply
Completing Lessons Upload Images   Link 
Eric Dale 
7 months ago
Hi All,

Just wondering when all these lessons will be completed.
Richard Rost
7 months ago
Aiming to finish up D19 this week and start on D20. Been busy with a couple of other issues (business and personal). I hate making time tables because it's difficult for me to keep a scheduled routine. I suffered an injury back in February which left me blind in one eye, and some days I get real bad migraines which force me to lay in the dark and avoid screens. So I have lots of plans for things I want to get finished, and I know how long things SHOULD normally take me to finish, but I never know if I'm going to be able to work on any particular day or for how long. Even on a good day I can usually only work for 3 to 4 hours before the headache sets in.
Richard Rost
7 months ago
If you meant "all these lessons" meaning all of the Developer series, I have no idea. There is no end in sight. I literally have dozens of real good books on Access VBA Programming and I've barely scratched the surface on what Access can do. I wouldn't be surprised if there are 30 to 50 levels by the time I'm happy calling it "completed."
Add a Reply
Recordset Clone Upload Images   Link 
Selby Halfpenny 
8 months ago
Dear Richard, Can you explain what a Recordset Clone is and how they are used.
Thanks. All the best Selby
Alex Hedley
8 months ago
See this forum post.
Richard Rost
8 months ago
Thanks, Alex. Selby, you can see from my previous post how much I use Recordset Clones. That post was 12 years old and I haven't used once since. :)
Add a Reply

Start a NEW Conversation
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:

7/29/2021Event Enrollment
7/28/2021Membership Database
7/27/2021Quick Queries #5
7/27/2021Loop Thru Fields in Table
7/26/2021First Monday
7/25/2021Missing Months
7/24/2021Center Vertically
7/22/2021Buy Access
7/21/202164-Bit Access

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
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
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access developer 19 lessons  PermaLink