If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reports with Images in Print Preview mode are slow to navigate pag
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. |
#2
|
|||
|
|||
Reports with Images in Print Preview mode are slow to navigate pag
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" 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. |
#3
|
|||
|
|||
Reports with Images in Print Preview mode are slow to navigate
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. "Tom Ellison" wrote: 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" 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Image repeats on another page in print preview mode | Tina M | Publisher | 0 | December 4th, 2005 04:29 PM |
Matching Print Preview to Two Page Editing Layout w. Mirror Margin | MichaelM | Page Layout | 1 | August 24th, 2005 03:33 PM |
Print preview reports in a VBA loop? | Margaret Bartley | Setting Up & Running Reports | 1 | May 25th, 2005 04:02 AM |
Default zoom setting for print preview of reports?? | John Schmidt | Using Forms | 3 | March 18th, 2005 09:01 PM |
Unable to print, page setup or preview | Jan Il | Outlook Express | 2 | January 23rd, 2005 09:10 PM |