How to Find Gaps in Your Check Number Sequence in Microsoft Access

In this Microsoft Access tutorial, I will show you how to find gaps in your check number sequence using the check register database. You'll learn to use VBA, the IsNumeric function, the NZ and DLookup functions, and perform loops to identify missing checks efficiently.
Carlos from Pflugerville, Texas (a Platinum Member) asks: I'm using your Check Register TechHelp database. Is there any way to quickly figure out if there are any missing checks from the register? For example, if I've for 101, 102, 104, and 105, I'd like the database to tell me 103 is missing.
BECOME A MEMBER:
RUclips: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
Missing Check Numbers: 599cd.com/Miss...
PREREQUISITES:
Check Register: 599cd.com/Chec...
Intro to VBA: 599cd.com/Intr...
IIF Function: 599cd.com/IIF
CLng Type Conversion: 599cd.com/Type...
IsNumeric: 599cd.com/IsNu...
For Next Loop: 599cd.com/ForNext
NZ Function: 599cd.com/NZ
Variables: 599cd.com/Vari...
Null: 599cd.com/Null
DMin: 599cd.com/DMin
Dmax Function: 599cd.com/Dmax
Dlookup Function: 599cd.com/Dlookup
UP NEXT:
Missing Check Numbers, Part 2: 599cd.com/Miss...
RECOMMENDED COURSES:
Check Register Seminar: 599cd.com/1404
Check Register Template Only: 599cd.com/1405
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Mi...
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
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,, find gaps in check number sequence, identify missing checks in database, gap detection in Access, check number sequence VBA, missing check numbers report, if function in Access, immediate if usage, CLNG conversion, isNumeric function Access, forNext loop Access, Dmin function Access, Dmax function Access, Dlookup function Access, nz function Access, query design Access
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[@Shadow.Dragon]

Very interesting video, Richard! Looking forward to the next in the series!

[@alializadeh8195]

Thanks

[@phillavonas3285]

Have a question regarding searching for data. I have a stock room and I want to have a form for checking out inventory. I'm trying to allow people to search for inventory, first by using a list box to narrow the search into a part number, description, category, location and then I was going to also use a text box. I was thinking someone selects let's say category and types glasses then the results would be displayed if they mett both criteria in an output box. Or maybe they know the location the item is in and the type in the location and the result would display all parts that are in that location. How would I do this? Thank you