Use Wildcard in Query for Multiple File Types - Images in Microsoft Access


	Back to Images Comments List

Upload Images @Reply Bookmark Link Email

Use Wildcard in Query for Multiple File Types

Lisa Snider

5 months ago

I am implementing Richard's procedure to save images in a folder under the database folder. The problem is, of the over 700 images I have, half are .jpg, the other half .png. Is there a way to use wildcards in a concatenated string in a query? Do I have to choose one file type over another and convert the other images? Or is there a third choice that (right now) is beyond me? I'm sure the eventual users of my database will encounter the same issue.

My query code now is:
ProductImage: [CurrentProject].[Path] & "\ProductImages\" & [ManufactureStock#] & ".PNG"

Thank you for taking a look. >^..^<

Kevin Robertson @Reply

5 months ago

Add this to a Global Module:

Function GetImagePath(ManufactureStockNum As String) As String



    Dim FolderPath As String, FileName As String



    FolderPath = CurrentProject.Path & "\ProductImages\"

    FileName = Dir(FolderPath & ManufactureStockNum & ".*")

    

    If FileName <> "" Then

        GetImagePath = FolderPath & FileName

    Else

        GetImagePath = ""

    End If

    

End Function

You can then call this function from anywhere in your database, including your Query.

	Lisa Snider OP @Reply 5 months ago
Thanks Kevin, but I'm confused. How does this module relate to the query I've written?

	Kevin Robertson @Reply 5 months ago
Call the function in your Query to get the full path including the appropriate extension. `ProductImage: GetImagePath([ManufactureStock#])` Note: I wouldn't use special characters in your field names. Watch this video: Create Function

	Lisa Snider OP @Reply 5 months ago
THANK YOU, KEVIN! You are the GOAT! (Sorry Richard) This works perfectly. (I got rid of the # sign... guess I wasn't thinking of the problems it could cause when I first named the field. Thanks for pointing it out.)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Images.