[AccessD] Max #loops in VBA report Generation

Judy,

  Off-hand, I can't think of anything.  What I'd do is stick a stop in after
the 103rd loop or so, step through the code making sure it's doing what you
think it's doing.  Then when you hit the 105th, find out what line it's
getting stuck on or if it's getting caught in an infinite loop.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Judy Johnson
Sent: Friday, March 14, 2008 7: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