Relational Linking to Images

[fauxanadu]

Question:

How does one create a relational link to an image in Access? In other words, instead of an image control with a path of "C:/Database Folder/Images/image001.jpg", I want to be able to link to "./Images/image001.jpg"

Technical:
Tables:

tblIndex

numMapID (primary)
numXCoord
numYCoord
lnkMapPage
lnkMapThumb

tblProjPages

numPageID (primary)
numMapPageID
lnkProjPage

Relations

numMapID one to many numMapPageID

Forms:

frmTest (test form)

picTest (picture control)

Move Information:
Each Map Page can have any number of project pages attached to it, but only one original map page. The images are stored in fldImages. When, in the database, I make a form's image field Picture Property = "/fldImages/001.jpg" or "./fldImages/001.jpg" or "fldImages/001.jpg", it gives me a "file not found" error. The database is being developed on a PC and then being transfered to a server where I will not know what the actual path to file is and as such I either need to dynamically extract that information using the built in VB tools OR create a link to the picture that is relational to where the database is stored.

[Denburt]

You can use this but this will also give you the database name at the end, you will want to modify it to fit your needs.

Application.CurrentProject.FullName

[ADezii]

Question:

How does one create a relational link to an image in Access? In other words, instead of an image control with a path of "C:/Database Folder/Images/image001.jpg", I want to be able to link to "./Images/image001.jpg"

Technical:
Tables:

tblIndex

numMapID (primary)
numXCoord
numYCoord
lnkMapPage
lnkMapThumb

tblProjPages

numPageID (primary)
numMapPageID
lnkProjPage

Relations

numMapID one to many numMapPageID

Forms:

frmTest (test form)

picTest (picture control)

Move Information:
Each Map Page can have any number of project pages attached to it, but only one original map page. The images are stored in fldImages. When, in the database, I make a form's image field Picture Property = "/fldImages/001.jpg" or "./fldImages/001.jpg" or "fldImages/001.jpg", it gives me a "file not found" error. The database is being developed on a PC and then being transfered to a server where I will not know what the actual path to file is and as such I either need to dynamically extract that information using the built in VB tools OR create a link to the picture that is relational to where the database is stored.

If this is just a Single User Database, why not simply create an Images Folder under any Folder you designate as the Folder location for the Database. Copy the Image Files into this Images Folder and use the following code to locate them:

Debug.Print CurrentProject.Path & "\Images\" & "Image_File.jpg"

Output:

C:\Documents and Settings\security\My Documents\Images\Image_File.jpg

[Denburt]

Sorry this is more what you asked for:

Application.CurrentProject.Path

[Denburt]

You got it ADezii.

[fauxanadu]

Those both work. Once I figure out how I want the output generated I will decide on which one to use. Thank you both for the prompt replies!

[Denburt]

Anytime :)

[ADezii]

Those both work. Once I figure out how I want the output generated I will decide on which one to use. Thank you both for the prompt replies!

You're more than welcome.

[ADezii]

You got it ADezii.

Thank you, Sir.