Hello, I'd like to insert a linked image into my form header. Trouble is, it alternates between drives - the source file for both the image and the database are within my USB device, but I use it at home and school. At home, it is allocated the I: and at school it is the E:. Therefore each time I switch between home and school (daily) I get error messages saying "E:....." cannot be found (when at home) and vice versa with the I: at school. Is there a way to define the image source so that it comes from within the same folder as the database file, rather than a full address? This kind of thing can be done in HTML, with which I am very familiar, but I'm starting to wonder if Access will have the same capabilities. I need this to work because our databases have to be submitted to external assessors at the end of the year, and I can't have the images broken or else I'll not get a very good grade.
I tried simply changing the path to "image.gif" (to denote the same folder) but it immediately reverted back to the full path.
You can also use;
a. Application.CurrentProject.Path property to get database path
b. Application.CurrentProject.Name property to get database name.
c. Application.CurrentProject.FullName property to get full path and name.
In this case CurrentProject.Path property what you are looking for I guess.