Wildcard in file path name?

S

Skip

I have an Access report which displays a picture of the corresponding data by
referencing the file path in the table. The problem I have is the file names
of the phots are not consistant. For example the path might be
c:\pictures\R311.jpeg and another might be c:\pictures\R314front.jpeg. What
I'd like to do is put a wildcard in the path after the fourth character so it
will find all of the pictures. Would this be code or something I can do to
the access table?

I'm fairly new to VB code but have found a lot of useful information in this
newsgroup to get me by except for this problem.
 
T

Terry

Skip,

What are you trying to display in your report? Is it one
picture per record or are you trying to display as many
pictures as you can find - eg r314front.jpeg,
r314back.jpeg, r314inside.jpeg, etc ...? - I hope it is
only 1 picture.

The "dir" function will return the path and name of a file
matching wildcard parameters. See VBA help for a complete
rundown on usage.

Terry
-----Original Message-----
I have an Access report which displays a picture of the corresponding data by
referencing the file path in the table. The problem I have is the file names
of the phots are not consistant. For example the path might be
c:\pictures\R311.jpeg and another might be
Click to expand...
c:\pictures\R314front.jpeg. What
 
S

Skip

Thanks Terry!

The Dir command worked great and yes I was just wanting to grab the first
photo that met the account criteria.
 
Top