Picture

[Disneygirl25]

Hello! For my database report, I have to include different pictures for each page and when I first opened the database, it had c:\pictures\two.jpg. When I first ran the report, the image frame was left blank and it did not work. Then I had to go back and change the url to C:\Users\Abby\Pictures\two.jpg. When I ran the report for the second time, it works. So my question is, if I run the report on another computer, will the pictures come up on the image frame? If not, how do I get the pictures to where they will show up on the report on all different computers? Thanks!

[twinnyfo]

Disneygirl25,

The “short” answer is that you should have your DB back end and all supporting images that you might use in a shared network environment. Thus, whenever anyone is accessing the two.jpg image, it is from a shared, known location, such as “\\ServerName\Folder\Images\two.jpg”.

There are different ways to do this. Let us know if you need further guidance.

Hope that hepps!

[NeoPa]

Hi Abby?

This all depends a great deal on exactly what you're trying to achieve. Unfortunately your question is a bit short on information.

If the picture is a standard one and everyone should be able to access it then it should either be on the network accessible by all users the same way (Many ways to handle this depending on variables we know nothing of.) or copies of it could be made accessible on all machines expected to run the project.

On the other hand, if you're talking about different pictures being used for each record then we have a totally different situation. That one would require a file address (again must work regardless of which machine it's run from) to be stored in each record and that address being set to the Image Control's .Picture property in the Section's Format() event procedure.

[Disneygirl25]

NeoPa, it’s four different pictures for each record

[NeoPa]

In that case you'll need four separate controls on your report and four separate fields in your table to hold where these pictures are loaded from. The files must still be in such a place as to be accessible - in exactly the same way - from anywhere the project is run.