B
bhammer
This question is not about displaying photos in a database, but about finding
a matching record using a partial string search or filter.
A photo database is setup to display side-by-side comparison photos. The
description field of the comparison photo contains a sentence or two plus the
filename of the original photo is matches, so it can be related to it. I want
to display the current and comparison photos on the Main form, with a list of
all photos in datasheet view on a Subform.
I have this working for the one, current, photo. I want to add the
comparison photo side-by-side.
The user scrolls down the datasheet on the subform listing all records. The
current record has a text field (txtFilename) that contains the string
"DSC0123.jpg", and somewhere in the txtDescription field is the number
portion only of the filename, like "0123". How can I find the other record in
the list that has the same text in part of the memo field (txtDescription).
Then how can I return the txtFilename of the matching record?
Brad
a matching record using a partial string search or filter.
A photo database is setup to display side-by-side comparison photos. The
description field of the comparison photo contains a sentence or two plus the
filename of the original photo is matches, so it can be related to it. I want
to display the current and comparison photos on the Main form, with a list of
all photos in datasheet view on a Subform.
I have this working for the one, current, photo. I want to add the
comparison photo side-by-side.
The user scrolls down the datasheet on the subform listing all records. The
current record has a text field (txtFilename) that contains the string
"DSC0123.jpg", and somewhere in the txtDescription field is the number
portion only of the filename, like "0123". How can I find the other record in
the list that has the same text in part of the memo field (txtDescription).
Then how can I return the txtFilename of the matching record?
Brad