Re: Memory for rendering a report page

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

To reduce your memory foot print per page you must:

1) Use the Print event, NOT the Format event, to load your images into the
Image control.

2) Turn off the Loading Image dialog via the Registry.

This is an old Bug caused by the "Loading Image" dialog. Here is a previous
post of mine on this issue.

If you do not stop the "Loading Image" Dialog via the Registry modification
you will run into two issues:


1) Access can crash if you scroll through the records too fast.


2) When printing a Report, Access may run out of resources and be
unable to complete printing the report.


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.


------------------------------------------------------------------------


If after modifying your MDB for #1 and #2 above still leaves you with a lack
of resources to complete the print job then you can try:

3) Use the fLoadPicture function on my site to load your large images into
the Image control.
http://www.lebans.com/loadjpeggif.htm


Finally, if implementing all of the above does not resolve your issue then
you will have to programmatically print out a few pages of your report at a
time.

--

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


"anthony" <anthony.marrian@xxxxxxxxx> wrote in message
news:a0fe9141-3b1a-450b-bbfd-890ef7306c08@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Does Access limit the amount of memory needed to render a report page?
If so, is it possible to increase the default?


.

Relevant Pages

  • Re: footer appearing when it shouldnt in Microsoft Access Reports
    ... I don't have your data and report to work with. ... it prevents the image control on the footer from ... The only control in the footer is the Image control to display the flow ... If I can't figure out what is causing the Format or Print event to ...
    (microsoft.public.access.reports)
  • Re: Sizing an image control
    ... in the Print event. ... your code below is missing the call to actually resize the Detail ... section itself(after you set the Visible prop of your Image control). ... to set a border for the detail section of another report. ...
    (microsoft.public.access.reports)
  • Re: Flash Report layouts
    ... If you have a jpg or gif file that results from your scan, you can load this ... somewhat and you may find that its better to actually add an Image control ... to the detail section of the report, size it and then load the image; ...
    (microsoft.public.access.reports)
  • Re: Ole Objects
    ... Add a hidden Image control to the form in question. ... Picture" into this control. ... Load the default pic into an Image control. ... I have to modify the report. ...
    (comp.databases.ms-access)
  • Re: Object Frame
    ... Use an image control. ... Leave the image files outside the database and simply ... Then in the on print event of the report, ...
    (microsoft.public.access.reports)