Standard Path for files to be called in VBA

[recyan]

The Background :
I have a folder (mydb) with an access db in it.
This folder also has a couple of files ( image files ( myImage.jpg), doc files, etc ) in it.
These files are called in VBA in a module in the db.

The Problem :
The path for a file in VBA on my computer is something like :
<img src='D:\my Data\Docs\mydb\myImage.jpg'" & "width='330' height='200'>"

Now if I want to test on a different computer, the path unfortunately most of the times is bound to be different.



Is it possible to avoid having to change the path in VBA, every time I work on a different desktop?

Thanks

[June7]

The folder is located on central shared server? Try UNC pathing: \\servername\path\filename

[recyan]

No. These are totally different independent desktops.
For eg.
On my Computer, the path :
<img src='D:\my Data\Docs\mydb\myImage.jpg'" & "width='330' height='200'>"

On a second Computer, the path could be :
<img src='C:\My Documents\mydb\myImage.jpg'" & "width='330' height='200'>"

On a third Computer, the path could be :
<img src='E:\Personal Docs\mydb\myImage.jpg'" & "width='330' height='200'>"

Thanks
Thanks

[recyan]

Think I may have got it :
Perhaps use below to get the access db Folder Path & then concatenate the file name with extension.

"Application.CurrentProject.Path"

Thanks

[June7]

So the folder could be anywhere, even on user's local drive?

Oh, just read the OP again - the db and the files will always be side-by-side in the same folder?

Try:

"<img src='" & CurrentProject.Path & "\myimage.jpg' width='330' height='200'>"

[recyan]

Yes June. Tested it. It works on my comp.
Should be able to test it on a different comp later.
Will keep you posted.

Thanks