Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subreport in report producing IPF

Status
Not open for further replies.

AnalystDBA

Programmer
Jan 2, 2002
20
0
0
AU
Hi all,

Can anyone help with this one?

I am using Access 97
I have a basic report based on a static table in Access.
I am trying to insert 2 sub reports into the main report to total data for each segment of the report (ie sales by territory,area and manager with a total for area and manager). The sub reports are also based on a static table in the database. No querys to speak of in these reports.
The problem I have is, when I insert the second sub report into the main report I keep getting IPF's when I try to print the report. The wierd part is that the report previews OK. I only get the IPF when I try to print
I have copied the error message I am getting below.

MSACCESS caused an invalid page fault in
module MSACCESS.EXE at 017f:300f5243.
Registers:
EAX=00000000 CS=017f EIP=300f5243 EFLGS=00010246
EBX=00d89b34 SS=0187 ESP=0062ea50 EBP=0062ea58
ECX=062d0684 DS=0187 ESI=00000000 FS=1ba7
EDX=00000000 ES=0187 EDI=00000000 GS=0000
Bytes at CS:EIP:
8b 06 8b 40 04 85 c0 89 45 fc 74 0d 83 f8 ff 74
Stack dump:
062d0684 062d0684 0062ed24 300e8e7c 00000000 00000000 00d89a30 bff773a9 300e8c8f 00000000 00000000 00000000 061d706c 061d706c 00000004 00000004


I have tried compacting and repairing the database and this did not help. I have also tried printing to another printer and reinstalling the printer driver. I have even tried printing the report from another machine (I got the same IPF error). I have also rebuilt the report from scratch thinking that it might have been a corruption in the report object.
has anyone else had this problem and if so, do they know of a fix???

Cheers,
AnalystDBA
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top