Images on a report

[Greg Casper]

I have a report which is essentially a master list of personnel. For each
person on the list I print some standard info AND their photo. These are
..jpg images originally taken by a digital camera. I am using an image
control and then, in the detail section of the code behind the report,
specifying which photo to print. This all works fine. My problem is, it's
VERY slow importing all the photos as it goes AND, when it gets to about the
50th person on the list, it runs out of memory and I get an out of memory
error message for each succeeding person.

Is there a more efficient way to do this? How do I get the report to print
for ALL employees?

Thanks

 

[Guest]

You need to increase your print spooler memory - or try output in bayches
(like when you print from adobe or correl).
If all else fails you will need to save your photos to the server (not in
the D Base) and then link to the pictures (use the OLE type allowed - click
"either" on the OLE object properties).

The main problem is the Access is not cleint/server based and at the moment
(if I understand it right) you are running the client section and printing to
a server based printer. So (as above) save the pictures to the server side
and link to them. This way you should aviod the problem of your printer
spooling the client side.

 

[Greg Casper]

Thanks Wayne:

I AM linking, not embedding, the pictures. Since the whole process is taking
place on my PC, I'm not using a seperate server. But I'm using an image
control and then, via code, setting the .picture property of the control to
the picture I want displayed. So I think that qualifies as linking, right?
So maybe the only option is to increase my spool size. Any other
suggestions?

Thanks again.

 

[Stephen Lebans]

Here's a previous post of mine on this issue.

The one thing you must do is turn of the Loading Image dialog. If you don't,
and quickly scroll through the records in Form view, or page quickly in
Print Preview, you run the risk of crashing Access. Use the Registry mod at
the Access MVP site:


Additionally, two issues in regards to the Registry modification pointed to
here http://www.mvps.org/access/api/api0038.htm


1) The Registry key MUST be "No" NOT "no" or "NO"


2) On systems with XP or on systems with more than one user account,
you must add/modify the key in both HKEY_CURRENT_USER and
HKEY_LOCAL_MACHINE.



--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

I have a report which is essentially a master list of personnel. For each
person on the list I print some standard info AND their photo. These are
..jpg images originally taken by a digital camera. I am using an image
control and then, in the detail section of the code behind the report,
specifying which photo to print. This all works fine. My problem is, it's
VERY slow importing all the photos as it goes AND, when it gets to about the
50th person on the list, it runs out of memory and I get an out of memory
error message for each succeeding person.

Is there a more efficient way to do this? How do I get the report to print
for ALL employees?

Thanks

Greg I've been reading your post and perhaps you can help me.
I have a similar application where I want to use a report to print ID cards
My problem is that the report will populate all records with the same image file.
The report has two columns The following code is set on the reports activate event:

Private Sub Report_Activate()
Dim StrProp
Dim StrPic
Dim db As DAO.Database
Set db = CurrentDb
Dim Rst As DAO.Recordset
Set Rst = db.OpenRecordset("control") 'This is a tabe with dirrectory path
strPath = Rst!Path 'The field named "Path" eg:C:\xxxxxxx\
StrPic = [Reports]![SecurityID]![PictureTxt] 'This is a control on the report
StrProp = strPath & StrPic
Image15.Picture = StrProp
End Sub

To my understanding this should set the picture property value of the image >control to the value of the report's [Pictue Txt] contol which has as record source
The [Picture] field in the reports data source.
I could use all the help I can get. Thank You.

ps: I can not figure out how to post a new question..........