May 1 2008, 11:21 AM
I have a database that was written by a previous employee who is no longer with he company. For a while now I've been having trouble with one of the reports.
Specifically, if I make a change to the report in Design View (say resize a lable) and then switch back to preview mode it takes up to 15 minutes for control to return. It takes an equal amount of time to save the change.
Does anyone have any idea how I can approach solving this problem? I'm not sure where to start...
May 1 2008, 11:52 AM
Well just a quick one, but has the db been comapcted and repaired?
May 1 2008, 11:53 AM
Yes it has....
May 1 2008, 03:14 PM
Is the report boiund to a control source? If on the Properties window, a controlsource is listed, you could simply remove it from there, and place it in the OnOpen event of the report, thereby simply simply adding the statement:
Me.Recordsource = "source"
Or, I believe if there are several subreports, that tends to bog down the save time.
Hope that helps a little...
1. Have you checked the RecordSource of the Report independently from the Report?
Run the Query / SQL used as the RecordSource and see how fast/slow the data is retrieved.
2. Have you check the Name AutoCorrection options?
Disable them all if they are not already disabled.
3. Have you checked the Page Set-Up of the Report?
Reset to "Default Printer" rather than a specific printer.
May 2 2008, 06:43 AM
Last night I came across the topic of "Name Auto Correction" in a book that I have. When I got in this morning I turned that off and now all is well. Thanks to everyone for thinking about my problem and posting suggestions.
So Van's #2 suggestion seemed to be the culprit in my case - thanks Van!
You're welcome ... Glad we could help ...
Jul 15 2008, 02:52 PM
I'm so happy I found this thread!!! Woohooo hours of saving have been... urrrrr... SAVED!!!!
Jul 15 2008, 09:21 PM
That's why we use forums where questions and advices / answers are archived and available for other members to search for...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here