Module to create multiple reports crash

[wishlish]

I have a Do Until Loop that creates a filter critera, DoCmd.OpenReport's the report with the criteria, SendObject's the report two times (in different formats, so different customers don't have to use Snapshot while others can), closes the report without saving, and then loops back, getting the information on the next customer. When it tries to OpenReport again, though, Access crashes. I get this message:

MSACCESS caused an invalid page fault in
module KERNEL32.DLL at 0187:bff7a388.
Registers:
EAX=656d6863 CS=0187 EIP=bff7a388 EFLGS=00010202
EBX=00000060 SS=018f ESP=00626f84 EBP=00626fa8
ECX=61747461 DS=018f ESI=0a23f184 FS=5447
EDX=0a140000 ES=018f EDI=00736908 GS=0000
Bytes at CS:EIP:
89 41 08 8b 56 04 8b 46 08 89 50 04 8d 04 1e 50
Stack dump:
00736908 00000000 0a14000c 0a140000 0a23f184 00000040 00000000 0000a975 0000a240 00626fd0 bff7a550 0a140000 0a23f184 00000060 00000040 0062ef04

Any idea why?

 

[StarPassing]

Check out

http://support.microsoft.com/default.aspx?scid=kb;en-us;q260819

It states in part:

This behavior can occur if either of the following conditions is true:

There are too many characters in the message. This behavior has been documented with messages that contain between 70 and 2268 characters.

NOTE: This number may be higher or lower on each computer. -or-

The SendObject method runs more than one time in a procedure.

 

[wishlish]

I fixed the problem, and I *think* I found the problem.

I had started this database in Access 97, and converted it to 2000 to work on at home (I have 97 at work). That's where it crashed. When I converted it back to 97, and ran it at work, it ran fine.

I did a search on the forums, and I found 3 other instances of crashes when converting back and forth. One specifically was doing what I was doing- a Do Until loop with Outlook commands.

But the link you attached also makes sense. Thanks!

Thanks to everyone for their help with this project! I'm DONE! WOOHOO!!!!!