wildcard help

[travismp]

[CheckID]
[ImageLink: "C:\Images\"+[CheckID]+".tif"]

These are two fields form my query. [CheckID] is a unique number tracked in my table for each client. I have a form that I type a CheckID into and data will display AND a scanned tif image will load on the form based on the [ImageLink] for each client.

[CheckID] is always 10 characters long and a number. When I scan the tif image I will save it to the images folder with the name of the number.

Sometimes I may need to scan multiple sheets of paper for each [CheckID] in that situation I will label them xxxxxxxxxx(1), xxxxxxxxx(2), ect...

Can I change this [ImageLink: "C:\Images\"+[CheckID]+".tif"] to look for those (1) (2) documents as well?

So when I type "0049580585" it would find images "0049580585.tif" "0049580585(1).tif" & "0049580585(2).tif"

Thanks.

 

[DCrake]

Here is a demo version of a similar issue that was resolver for a former poster. Hope this helps

 

[DCrake]

In the demo I gave you The filter field could be used to enter the

1234567890 part of the file name and the Extension could be tif. When click on find Files it would display all files like 123etc*.tif in the list box.

If you leave either of the fields blank it uses * as the comparison (see code)

What you do then is double click on a particular file name and it would open up in its native software.

At present the location is hard coded to look in the current project path (Where you have saved the demo to) this could be revised to use the server path to the images.

 

[travismp]

DC Thank you. I looked at this last night and it is over my head because I am not good with VB, however I do know enough to get it to work with my db. THANK YOU for the demo, very cool stuff.