var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How deep can you nest reports in access 2000?
i have a report (1)that has a subrpt (2) that has a sub report(3)
#1 displays in print preview, but when i print the fields in sub #2 that ref that rpts sub #3 display #error
when i print #2 (sub report of #1) i dont get any error.
HELPPPPPPPPPPPPPPPPPPPPP!!! i have been trying to do this for 4 days
original post : http://www.dbforums.com/showthread.php?t=1625877
I found the culprit, i deleted 2 sub reports on the final report and the error whet away, now the question is why?
fixed it, i used a make table qry for the lowest subreport and set the reports record source to the table made....NOW! how do u run a make table qry from a macro? i tried openquery and runsql niether work...
never u mind... I forgot to save as make table qry it was running as select
Last edited by mikezx10; 12-31-07 at
Owner and Manager of
. , Microsoft Access Development Specialists CypherBYTE
Microsoft Access . MCP
And all around nice guy! "Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "
For number of nested subreports/subforms;