Relative Path to Background Image (A2k)

Topic

New Reply

Hello.

I use images stored as jpg outside the db and linked with code using examples learned here. Thanks for showing me that!

Right now I am trying to have the background image behave the same way.

I use the dialogs and navigate to the file so that it the path to file reads C:/images/backgrounds/back.jpg
Set property to Zoom and Linked.
All is well.

If I move or send by email for others to use,,,, (sending or moving the folder containing the MDB and images)… I need a relative path for the back ground image… right?

In Picture property I input the relative path to image I want to use. When I open the form in design view of preview I receive an error saying that file can not be open. (see ‘error.bmp’ attached)

I have tried using several different combinations (examples below) as the relative path. All produce the same error
//folder_with_mdb_in_it/folder/file.jpg
/folder_with_mdb_in_it/folder/file.jpg
folder_with_mdb_in_it/folder/file.jpg
//folder/file.jpg
/folder/file.jpg
folder/file.jpg

It seems to work once. Then on close and re-open the error returns.
I tried a decompile thinking it may be some type corruption thing… no luck.

What seems to be the problem here?

Thanks.

Jason

Reply | Quote

Replies

You’d have to leave the background image blank in design view, and set it in code. You can use CurrentProject.Path to obtain the path of the database dynamically.

Reply | Quote

Thank you Hans. As always. Your instructions worked perfectly.

I used the following and it worked.
placed image file in same folder as MDB. Named image back.jpg
Then used this code.

Private Sub Report_Open(Cancel As Integer)

Me.Picture = CurrentProject.path & “back.jpg”

End Sub ‘Form_Open(Cancel As Integer)

Reply | Quote