How to type in file name and get notified if it is in a directory

[Book Guy]

We have a large database of graphic files. The file names match the barcodes
we will be scanning with the exception of a pdf extension. We are using
simple usb scanners to read the barcodes. I am wanting to be able to scan
the barcode on the object and get notified (or at least create an exception
report) of any file that is not currently in the database. I can use a
lookup table if the filenames were in a table but due to the very constant
addition of new files, the upkeep on the table seems difficult and not
real-time.
Thanks.

 

[Dennis]

Why would you not just add the name to the database automatically if it
doesn't exist, with a popup MsgBox telling you that it was a new file, and
"auto-added" ??

 

[Book Guy]

It would just be adding the filename, not the contents so to speak.
Basically a receiving department doing the scanning to make sure a matching
file exists, if the file does not exist, the product must then be seperated
and go to a different department to be processed into the actual graphic file
that will then go into the large database and be ready for the next go-around.