report memory issue

scud11

New Member
Joined
Nov 15, 2005
Messages
2
Please help with memory issue:

I have created a query based report to show specifications for components in a manufacturing process. Each page of the report shows one component and 3 pictures of the component. (The pictures aren't stored as files in the db, only as url's to a lan address.) Right now I have 97 records, but the list will grow. When I display the report, I can only page through 15-20 records before the report craps out. I'm reasonably confident this issue is memory related.

I used the code from the following url to develop the report:

http://support.microsoft.com/default.aspx?scid=kb;en-us;285820#top

It was written for a single picture, so I had to create additional modules for each additional pictures. Following is the code from the report:

Option Compare Database
Option Explicit

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Me!Part_Picture_Note = DisplayImage(Me!Part_Picture_frame, Me!Part_Picture)
Me!Container_Part_Picture_Note = DisplayImage(Me!Container_Part_Picture_Frame, Me!Container_Part_Picture)
Me!Containers_on_Skid_Picture_Note = DisplayImage(Me!Containers_on_Skid_Picture_Frame, Me!Containers_on_skid_picture)
End Sub

The report works fine until the memory issue kicks in. (This issue comes up whether I try to view the report or print it.) Is there some way to get around this in view mode? Can the memory cache be cleared as I go from record to record? I could handle printing the report in smaller lots, but I'd hate to have to change the criteria for the query every time I needed to view a different record set.[/code]
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,449
Office Version
  1. 365
  2. 2021
  3. 2016
Platform
  1. Windows
Hello and welcome to MrExcel!

I'm not an expert with linked images but I suspect the size or format of the linked images will be causing the problem. How large are the pictures? Can you use smaller resolution pictures? Also, what is the file format of the pictures? There is a free image viewer and manipulator available from IrfanView.

If you wanted to print one part / page at a time, then you could do this with a form that had a combo box that you use to select the part. The report would be based on a query that references the combo box so this way you don't need to manually change the query criteria for each part.

Lastly, there are a couple of pages from the MS support website that might help, especially this one (see the section titled 'improve report performance') and maybe here.

I suspect the issue in your other post (of the repeating pictures) may also be contributing to the memory problem.

HTH, Andrew :)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,057
Messages
5,835,163
Members
430,343
Latest member
t0m_c

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top