Reports with Images in Print Preview mode are slow to navigate pag

[6611Prints]

I'm using Windows XP Pro with Office 2002. I have a 1.7 GHz processor with
496 MB of Ram. My users have similar specs.

I have split my database into a FE and BE. All the forms, queries and
reports are in the FE and the tables are in the BE. Each of my users has a
copy of the FE.

I have a report (with a query record source) with a small image frame that
changes images with each record in the detail section of the report (with a
maximum of 7 images/records per page). In the OnPrint event I have the
following code:

Me.imageframe.picture=me.[picture link]

[picture_link] field is a text field that contains the pathway to a jpg
picture on my network.

My report opens within 5-7 seconds (slower than I would like but within my
users’ tolerance levels, so that’s not the issue). However, when I navigate
to the second page, it takes a considerable amount of time to load the next
page, 20-30 seconds per page.

Is there a way to speed up the navigation of pages while the report is in
print preview mode?

Any suggestions will greatly be appreciated. Thank you.

 

[Tom Ellison]

Dear 66:

The answer is simple, or it it? The query behind the form is probably the
problem. Make it faster.

How? Well, you haven't given any details of it. Is it fast? Don't just
open the datasheet of the query, but scroll to the end. Does it take a
while.

If so, that would be the point of attack.

Tom Ellison

 

[6611Prints]

Hi Tom. Actually it's not the query. I've tried the report based upon a
table with only 7 records and with a query with one criteria:

SELECT [Order Packages].[Start Date], [Order Packages].[Cancel Date], [Order
Packages].CUT, [Order Packages].[Cut Link], [Order Packages].PO, [Order
Packages].[Official PO], [Order Packages].CUSTOMER, [Order
Packages].[Additional Description], [Order Packages].[Primary Fabric
Content], [Order Packages].[Secondary Fabric Content], [Order
Packages].[Fabric Quality Main], [Order Packages].MM, [Order
Packages].FACTORY, [Order Packages].STYLE, [Order Packages].Color, [Order
Packages].Print, [Order Packages].Qty, [Order Packages].[W/S PRICE], [Order
Packages].[EXT AMOUNT], [Order Packages].[Ex Fty], [Order Packages].[Main
label], [Order Packages].Remark, [Order Packages].Picture AS
PictureHyperlink, [Order Packages].[Picture Link], [Order Packages].Dim,
[Order Packages].[Internal Order No], [Order Packages].[Buyer Remark], [Order
Packages].ID FROM [Order Packages] WHERE ((([Order Packages].[Internal Order
No])=[Enter Internal Order Number])) ORDER BY [Order Packages].STYLE;

Basically it's the imageframe. If I remove the imageframe from the report
or keep the image to one image only...the report opens fine. It's when I
have multiple images that slows it down.

The whole process is little faster if I don't do a print preview but rather
send the report directly to the printer by calling a function
(DoCmd.OpenReport "Summary Report--Customer", acViewNormal, , , acDialog)
However, my users would like to preview the report first.

Any other ideas?

Thank you in advance.




:

Dear 66:

The answer is simple, or it it? The query behind the form is probably the
problem. Make it faster.

How? Well, you haven't given any details of it. Is it fast? Don't just
open the datasheet of the query, but scroll to the end. Does it take a
while.

If so, that would be the point of attack.

Tom Ellison


"6611Prints" <[email protected] wrote in message
I'm using Windows XP Pro with Office 2002. I have a 1.7 GHz processor
with
496 MB of Ram. My users have similar specs.

I have split my database into a FE and BE. All the forms, queries and
reports are in the FE and the tables are in the BE. Each of my users has
a copy of the FE.

I have a report (with a query record source) with a small image frame that
changes images with each record in the detail section of the report (with
a maximum of 7 images/records per page). In the OnPrint event I have the
following code:

Me.imageframe.picture=me.[picture link]

[picture_link] field is a text field that contains the pathway to a jpg
picture on my network.

My report opens within 5-7 seconds (slower than I would like but within my
users' tolerance levels, so that's not the issue). However, when I
navigate to the second page, it takes a considerable amount of time to
load the
next page, 20-30 seconds per page.

Is there a way to speed up the navigation of pages while the report is in
print preview mode?

Any suggestions will greatly be appreciated. Thank you.