update query to add ImageAvailable = True

[Maureen]

Good Morning!

I would like to make image files available from access in order to create a
"merged" cataloge. I have my report and query completed and it works great.
Now all I need to do is update my table with the path and file name to the
images. I am working with a single table [Inventory] with:

[Inventory].[ProdID] as the key, [Inventory].[PathtoImage],
[Inventory].[ImageName] and [Inventory].[ImageAvailable] (there are other
fields that do not affect what I need here. My PathtoImage =
\\graphics01\images the ImageName = [Inventory].[ProdID].jpg
[ImageAvailble] is a check box that defaults to false.

We have a few hundred images available and we are adding more each day, we
have over 20,000 products. I am hoping that there is a way to create an
update query with some code that will scour \\graphics01\images and when it
finds an image for a record have it set ImageAvailble to True

I know very very little about using VB in queries but I am quite sure that
this can be done. Any suggestions would be appreciated!

M