I have created a photographic log using access and a series of pictures that I have taken. I have some problems and have searched the forum to no avail.
Here is a summary of what I have done so far:
1. created a table with a field that contains the complete path and filename for each photo. Other fields contain info about the photos.
2. I created a report that includes an image control as well as a text box linked to the field containaing the path and filename.
3. the following code was added as an OnFormat event for the detail section of the report:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me![PictureImage].Properties("Picture") = Me![ImagePath]
End Sub
4. The report is currently set up so that 6 pictures print (or preview) on each page with caption info from other fields.
Problems Encountered:
1. I have abot 45 pictures ranging in size from 200KB to 1300KB. When opening the report, it seems to read in each pic at least once (seems like more) and ends up taking forever to open the report.
2. If I have more that 6 to 9 pictures in the Table, some pictures do not get loaded (seems random...starts happening on Page 3 and then gets worse).
3. It seems to read in each file again when I print the report (again, this takes forever) and the same pictures are missing in the printout.
4. The photo log will eventually have approx. 100 pics.
There must be a better way to do this. If someone can help, it would be greatly appreciated.
Here is a summary of what I have done so far:
1. created a table with a field that contains the complete path and filename for each photo. Other fields contain info about the photos.
2. I created a report that includes an image control as well as a text box linked to the field containaing the path and filename.
3. the following code was added as an OnFormat event for the detail section of the report:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me![PictureImage].Properties("Picture") = Me![ImagePath]
End Sub
4. The report is currently set up so that 6 pictures print (or preview) on each page with caption info from other fields.
Problems Encountered:
1. I have abot 45 pictures ranging in size from 200KB to 1300KB. When opening the report, it seems to read in each pic at least once (seems like more) and ends up taking forever to open the report.
2. If I have more that 6 to 9 pictures in the Table, some pictures do not get loaded (seems random...starts happening on Page 3 and then gets worse).
3. It seems to read in each file again when I print the report (again, this takes forever) and the same pictures are missing in the printout.
4. The photo log will eventually have approx. 100 pics.
There must be a better way to do this. If someone can help, it would be greatly appreciated.
