-
Solved: Need a msgbox to report to me the missing record number
In the list below you'll see record number 18423 is missing.(in reality that is not the number that is missing)
I do know though for sure that I have a record number missing and I know that a user almost certainly must have deleted a row, or worse yet possibly some cells, when they should have only voided it or made edits to it.
I need a quick way to report to me in a msgbox or similar, what record number is missing. So that I can correct any possible mismatching data. There are over 18,000 rows --
-- I'm under a bit of a time crunch to spot this, as the app., is down with a user waiting until I can repair and certify that the records are not corrupted... I will be very appreciative if you can lend me a hand asap.
(Col AA)---(Col AB) is empty
18438
18437
18436
18435
18434
18433
18432
18431
18430
18429
18428
18427
18426
18425
18424----
18422----
18421
18420
18419
18418
18417
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules