Report Preview and Print
The attachments are the same report one with a quality control section
at the end of the report and the second is the same report with the quality control section deleted. The form with quality control takes 10 seconds to load and the other 3 seconds.
I have tried deleting and copying the section from other reports that work fine.
This form is a main form with three subforms in the report footer.
What on earth could cause that?
at the end of the report and the second is the same report with the quality control section deleted. The form with quality control takes 10 seconds to load and the other 3 seconds. I have tried deleting and copying the section from other reports that work fine.
This form is a main form with three subforms in the report footer.
What on earth could cause that?
ASKER
The main form is a bound form and the three sub reports are linked to the main form by the Key field. They are, however, stand alone reports using their own query.
I see that the main bulk of your paper is about forms. That is usefull as I have had lot's of problems in the past with exactly that issue.
Regarding my report problem the key question is what could possibly be causing a 7 second delay until I delet some boxes and labels
I see that the main bulk of your paper is about forms. That is usefull as I have had lot's of problems in the past with exactly that issue.
Regarding my report problem the key question is what could possibly be causing a 7 second delay until I delet some boxes and labels
ASKER
This must be a corrupt form? How can I check
Why is your form using subreports instead of subforms? Or if you want a report, use a report instead of a form?
ASKER
So sorry Luke I get so tied up with the issue that I make a mistake. It should read Main Report not main form.
I have done more testing and it seems that when the quality control boxes are in the report footer the report is running a function that is not called from the report. The underlying query uses it but the query runs perfect when the report is not active. When I remove the quality control labels and boxes section it does not run. I think there is something corrupt here. It makes no sense at all. I just recreated the exact same quality control boxes and labels manually, rather than copying and pasting from another report and problem has gone.
I have done more testing and it seems that when the quality control boxes are in the report footer the report is running a function that is not called from the report. The underlying query uses it but the query runs perfect when the report is not active. When I remove the quality control labels and boxes section it does not run. I think there is something corrupt here. It makes no sense at all. I just recreated the exact same quality control boxes and labels manually, rather than copying and pasting from another report and problem has gone.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
This was the solution:
C:\Program Files (x86)\Microsoft Access Runtime\Office10\MSACCESS.EXE
In properties change the Compatibility Mode to Windows XP (Service Pack 3)
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Jet\4.0\Engines\Jet 4.0\MaxBufferSize
- For the Microsoft Access Runtime executable:-
C:\Program Files (x86)\Microsoft Access Runtime\Office10\MSACCESS.EXE
In properties change the Compatibility Mode to Windows XP (Service Pack 3)
- Amend the following registry key to 50000 (Decimal)
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Jet\4.0\Engines\Jet 4.0\MaxBufferSize
What are your link field(s) between your master and child subforms/reports?
Are you avoiding referencing fields rather than control names from the master? Here's a paper I wrote on that issue:
https://www.fmsinc.com/microsoftaccess/Forms/Subform/Master-Link-Fields.asp