In this Microsoft Access tutorial, I will show you how to determine who had an item on a specific date, coding with VBA, error handling, and employing functions like DLookup and NZ. Perfect for tracking rentals or loans, this practical lesson is a must-watch. This is part 2 of 2.
Silver Members & up get access to an Extended Cut of this video. In the extended cut, we will take the code we just wrote and rewrite it as a function, which can then be used in different parts of the database, including within a query to determine which customer had a product out on a specific date.
MEMBERS-ONLY EXTENDED CUT VIDEO:
BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: https://599cd.com/THMember
LEARN MORE:
Who Had Item 2: https://599cd.com/WhoHadItem2
PREREQUISITES:
Who Had Item, Part 1: https://599cd.com/WhoHadItem
NZ Function: https://599cd.com/NZ
RECOMMENDED COURSES:
Access Developer Courses: https://599cd.com/Developer
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
How to Use Access in 30 Minutes: https://599cd.com/30Minutes
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/
KEYWORDS:
TechHelp Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, VBA coding, DLookup function, tracking rentals, Access database tutorial, rental table, product lookup, VB editor, Null Zero NZ, date range check, Access form, query logic, Access VBA, compile VBA, Access Video Series Part 2, Access TechHelp
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
source