MS Knowledge Base article 285820

[Guest]

I have a small questions and answers database (with images) that I'm using to
learn access. I put in on a USB drive and move it around from PC to PC,
where dirve letter change of the USB drive. I used this article to display
my images, but I need to be able to pull up the images from the same
directory as my *.mdb database is in, but the kicker is the drive letter will
change. So all my images would be in \images directory in the same directory
as my Q&A databse. I tried ..\ and .\ instead of the drive letter, but no
luck.

 

[Duane Hookom]

The drive letter of the mdb is:
Left(Currentdb.Name,1)

 

[John Spencer]

You probably need to modify the line strImagePath = strDatabasePath &
strImagePathTo include the "Images\" directory strImagePath =
strDatabasePath & "Images\" & strImagePath"csinva"