Code for File/Pathname ?

[Matthew Therrien]

I have a table which stores jpgs and their descriptions. I
am linking to jpgs as opposed to embedding.

Is there some code or technique to discover or lookup the
file and path name of an object we insert into an OLE
image field ? That is to say - when we create from file
and link the object - we browse to the folder and insert
the object. We now have the object in our table field. So
can we now look up the file and path of that object and
then store it.

Thanks

Matthew Therrien

 

[Steven Burn]

Dim s As String
s = Dir$(App.Path, vbDirectory) & "\file"

--
Regards

Steven Burn
Ur I.T. Mate Group CEO
www.it-mate.co.uk