How to indicate database home folder

[Duck]

I am creating a client database in which I want to also store client
photos. The photos are stored in a subfolder of the folder in which
the database is created. How can I indicate in my VBA code which
populates the unbound image frame, the relative location of the photos
folder (relative to folder in which the database is created). I want
to be able to move the database to a different folder on different
computers.

 

[Doug Robbins - Word MVP]

ActiveDocument.MailMerge.DataSource.Name

will give you the path and name of the data source that is attached to the
main document. Easy enought to strip off the name of the data source and
append the name of the folder containing the photos

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP