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 > D22 > D22 Lessons < D21 Lessons | D23 Lessons >
Access Developer 22 Lessons

Welcome to Microsoft Access Developer 22. Total running time is 2 hours, 51 minutes, of which 73 minutes is free bonus material.

 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!


Delete solution D22L4 Upload Images   Link 
Jan Holm 
9 months ago
When selecting more than one record in the contactF and not using the "DeleteBtn", this solution worked for me:

Private Sub Form_AfterDelConfirm(Status As Integer)

    DoCmd.SetWarnings True
Richard Rost
9 months ago
Awesome Jan! Thanks for sharing. Sometimes the easiest, most elegant solutions escape me. :)
Add a Reply
Tag Property Upload Images   Link 
Timothy Smith 
9 months ago

Are we able to use the Tag property for security setting?  ie.. Fields we want locked or unlocked and use the loop to lock and unlock field.

example user is Staff then LastName is unlocked, FirstName is unlocked, Discount% is locked, and CustomerSince is locked. Read More...
Richard Rost
9 months ago
Absolutely. You can use it for whatever you want.
Add a Reply
D22 Lessons 3 and 4 Posted Upload Images   Link 
Richard Rost 
9 months ago
More great recordset examples.
Add a Reply
D21 D22 Upload Images   Link 
Michelle Maughan 
9 months ago
Hi Richard
Both D21 & D22 are in my course list but when i try to watch them the message says they are currently under development. I have requested for my account to be updated. Just thought you should know in case it's related to the "GoDaddy" upgrade. Read More...
Richard Rost
9 months ago
I just logged on to your account. I can see and play the courses just fine. Maybe the update worked. There is something weird going on with the MyCourses pages for those two however. The breadcrumbs aren't loading, but you can still get to the course page. I'll figure that out.
Add a Reply
D22 Lesson 2 Posted Upload Images   Link 
Richard Rost 
9 months ago
This one uses a recordset to apply payments to multiple orders, starting with the oldest, and continuing until either all of the open orders are paid off, or there's no money left. Really cool stuff. Working on more tomorrow. Should finish up D22 then and start D23.
Add a Reply
Great Ideas for D22 Upload Images   Link 
Richard Rost 
10 months ago
I've got four really good ideas from you (my beloved students) for lessons in D22 that fit really well with recordsets. Hope you guys are ready for some new RS examples! Coming this weekend.
Add a Reply
D22 Lesson 1 Posted Upload Images   Link 
Richard Rost 
10 months ago
This is a BONUS lesson for Developer 22. It is essentially this TechHelp video plus the Extended Cut members video. I am included it here because I realized that I haven't covered the Tag property in any of my regular classes yet, and I don't want my Developer students to miss out on a new concept. This is BONUS material, meaning the whole 35 minute lesson does not count towards your hour for this class.
Richard Rost
10 months ago
And yes, don't panic. D22 will be available for purchase later today. Those of you who are Connection and MYOLP members will get access to it shortly.
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:

10/10/2021Copy Text from Field
10/10/2021Access for Free
10/8/2021Label Resize
10/2/2021Criticisms of Access
10/1/2021Access Developer 32
9/28/2021Track Log On

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 22 lessons  PermaLink