DLookup v DCount v Recordset: Check if Records Exist

In this Microsoft Access tutorial, I will show you how to check if records exist in your database using three different methods: DCount, DLookup, and the recordset approach. You will see how each method works, compare their speed and efficiency, and learn best practices for determining if related records, like customer orders, are present. I will also explain why using domain functions in queries can be slow, and demonstrate faster alternatives with aggregate queries.

Richard from Concord, North Carolina (a Silver Member) asks: I'm deleting a record in my main table, but there are two supporting tables associated with the main record that could have data associated with that record. I wrote this, and it seems to work well enough, but my concern is if it is good code or not.

Members

In the extended cut, we will create our own Dexist function using the fast recordset technique. I will show you how to turn it into a reusable function that returns a true or false value based on whether records exist for the criteria you pass it, just like Dlookup and Dcount.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  File Download - Gold Members
• DExist in Code Vault - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• VBA
• If Then
• DLookup
• DCount
• NZ Function
• SQL with Access
• Recordsets

Links

• Aggregate
• Outer Joins

Recommended Courses

• Recordsets
• Recordset Types (Snapshot, Dynaset, etc.)

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 Merch Store - Get your swag here! Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, DLookup vs DCount, check if record exists VBA, recordset exists check, compare DLookup DCount recordset, fastest way check if record exists, DCount performance, DLookup performance, NZ function VBA, developer-level VBA lesson, SQL WHERE clause VBA, dbOpenSnapshot, aggregate queries, avoid domain functions in queries, count related records VBA, own de-exist function