Display image file name in query

[FishMan]

Hi
I have a table with records with a number of fields, one of them being
a OLE field linked to an image (BMP). When I use a form on a query to
search for individual records I display the data associated with the
record and the linked picture. It all works fine and the pic opens on
double click.

However, I also want to set up a query to pull all the data from the
table into a datasheet for copying to Excel. In this output I need just
the filename of the image in the correct field. At the moment all I am
getting from this query is "Bitmap Image" in those fields with a
linked image, and "Long Binary Data" in those without an image. I
would like the filename (file.bmp) or nothing to be displayed.

Please help!
FishMan

 

[bob]

There's no direct way, but this KB article contains a possible solution which simply parses the binary
looking for something that resembles a path. You might be able to use this in a form to loop through all
the records and save the path to a new field.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q311147