Track Item Ownership by Date in Microsoft Access

In this Microsoft Access tutorial, I will show you how to track rental item possession on specific dates using VBA and DLookup functions. Discover methods to streamline your rental business reporting, and learn to construct a relational combo box while mastering if-then statements and the IsNull function.

Audrey from Maple Grove, Minnesota (a Platinum Member) asks: I run a rental business, and occasionally I have to determine who had a particular item on a specific date for reporting purposes. Right now, I have to go through the various rental receipts to try to figure out who had the specific item on that date. Is there a way I can enter the date, select the item, and it will tell me who had that item on that particular date?

Prerequisites

• Intro to VBA
• DLookup
• Relationships
• Relational Combo
• If Then
• Status Box
• Null

Links

• Reserved Words
• ISO Date Format

Recommended Courses

• Access Developer Courses

Up Next

• Who Had Item, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, track rental item possession, VBA in Access, DLookup function, relational combo box, IsNull function, rental business database, specific item lookup, date-based item tracking, Access reporting tutorial, customer rental record, relational database design, product rental system, record rental transactions, item possession query, rental item database, VBA code for rentals