[AccessD] Max #loops in VBA report Generation

Dan Waters dwaters at usinternet.com
Fri Mar 14 07:57:00 CDT 2008


Perhaps putting a DoEvent line of code in your loop might help?  Can't hurt
anyway.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Judy Johnson
Sent: Friday, March 14, 2008 6:34 AM
To: AccessHelp
Cc: Mary Graziani
Subject: [AccessD] Max #loops in VBA report Generation

Hi - running Access 2002. Never experienced this problem before, the db has
been running almost 3 years.

The problem occurs on a subreport that contains code that actually builds
each line of the report from data in a temp table.

When the temp table contains 105 records the report generates perfectly. As
soon as another record is added Access hangs ("not responding" in Task
manager)
I know the 106th record contains valid data, I populated the temp table with
the same single record and as soon as I hit 106 records the report will not
generate.

I'm testing on a Vista machine with 2 GB RAM and >300 GB disk space so I
don't believe it's a resource issue? Unless there's some stacking going on
in Access that I've forgotten about?

Anyone heard of a bug? I can send the code.

Thanks so much.

Judy
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list