Background images in Forms and reports

[groengoen]

I have a database which fills in a 3 different forms, consisting of 2, 3 or 4 pages respectively. I am using a watermark or background image for the reports produced (i.e. the reports are copies of standard forms). My problems are:

a) The reports take too long to load if the images are embedded
b) The mdb size quickly becomes enormous if they are embedded.

I would rather use the linked option for the images because of a) and b) above as this solves these problems. This leaves a third problem:

c) If I use the packaging wizard to sell the product downloadably from a website it will be difficult to ensure that the links to the images are correct. Does anyone have any ideas?

 

[NigelShaw]

hi,

Are you using the access developers kit? If so, I'm not overly familiar as I use sagekey which let's me add other files.

As a safe guard

Have you tried creating a file in the same area as your program destination ( keep out of users and stick with common )
Adding the files you want included into this file
Compile from there

At least then if it's all created from that place, your program would install there too and any links would be correctly pathed.


Nigel

 

[groengoen]

I am using the access developers kit. I have to link to the image using a filepath. Are you suggesting using just C:\image.jpg for the directory?

 

[groengoen]

What is sagekey? Is it an alternative to the access developers kit?

 

[gemma-the-husky]

you can test a path to an image folder in code,

if theres' no image just trap the error and resume next

 

[groengoen]

I get the path to the image working ok. It is just that I am worried about how it will work when I send it packaged to another user.

 

[groengoen]

Actually I think I have sorted it out. When I package the db, I can package the image files, and they will be in the same program directory. I can point my link to this directory. The only trouble will be if somebody wants to install the db on any drive other than the C drive.