System resource exceeded

A

Amateur

My database is running OK.
If I want to create a report I get the above mentioned error message. Any
idea how to avoid that.
 
J

JoAnn

Amateur,
I have no idea if this will address your problem, but the first thing I
check when I have problems with reports is to verify that I have a default
printer mapped on the computer that I am using. Whether the printer is
actually hooked up or not is irrevelant. Access will not let you create,
edit or run a report if there is not a default printer identified.

Hope that helps,
JoAnn
 
A

Amateur

No, a default printer is connected

JoAnn said:
Amateur,
I have no idea if this will address your problem, but the first thing I
check when I have problems with reports is to verify that I have a default
printer mapped on the computer that I am using. Whether the printer is
actually hooked up or not is irrevelant. Access will not let you create,
edit or run a report if there is not a default printer identified.

Hope that helps,
JoAnn
Click to expand...
 
J

JoAnn

I am not sure what else to suggest that may be causing the problem. For
troubleshooting, I would suggest:
1) confirm that the recordsource for your report will open without error
outside of the report.
2) use a recordsource that you know will return a very limited number of
records, ie 1 to 10 records.
3) Check for coding in the report that may cause problem, ie recursion.

JoAnn
 
A

Amateur

Thanks for your help but I think it's better to split the report into two
reports - it seems to work.
Thanks
Klaus
 
6

'69 Camaro

Hi.
If I want to create a report I get the above mentioned error message. Any
idea how to avoid that.
Click to expand...

Ensure that the query the report is bound to isn't using a Cartesian join
(as Oracle SQL uses). Ensure that it's an ANSI SQL join, such as the
following join syntax:

SELECT *
FROM TableA INNER JOIN TableB ON TableA.ID = TableB.ID

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: http://DataDevilDog.BlogSpot.com http://DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
T

Tony Toews [MVP]

Amateur said:
If I want to create a report I get the above mentioned error message. Any
idea how to avoid that.
Click to expand...

Are you using graphics in the report? If so move the logic on the
OnPrint event rather than the OnFormat event.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top