Procedure too large

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

I have a sub procedure in a report. I want to add to it, but it is now at
64K. Help says to break it into 2 or more smaller procedures. How do I do
that?
 
Heather

"How" depends on "what" -- what is your procedure doing? Any chance it does
more than one thing?

If so, a natural 'break' would be to make each separate "thing" it does into
a separate (smaller) procedure, then use your "main" procedure to stitch all
the smaller ones together.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have a sub procedure in a report. I want to add to it, but it is now at
64K. Help says to break it into 2 or more smaller procedures. How do I do
that?
Click to expand...

One way would be to create a new Module in the database window; put a public
procedure in it, and have your report's code call it.

That's a heck of a big procedure. Are you perhaps using code to do something
(such as select from a long list of alternatives) that could better be done
using a table and queries? Perhaps you could post a small sample of the code;
there may be a better way to accomplish your task.
 
Back
Top