Unfortunately, I've been forced to create a report using an ADO recordset that is populated along the way from 3 different DAO recordsets, so I can't re-create the results in a SQL query. In order to do so, I've relied on an article from MSDN, but it was an Access97 item, and I'm in A2002.
I've populated the detail_format and detail_print events with code that relies on the Print method and CurrentX/CurrentY placement to simulate my old report that was query-based. When I view the report in print preview mode, it's kosher. When I print from print preview mode, I only get 1 of 2 pages, and it's always the second page.
If I print from the database window w/out opening the report (right-click on the report and select "Print"), I get both pages and it looks perfect. The problem is that I've designed the database so that the users only interact with forms, not the database window. Also, I have to specify an "as of" date for the report to use, and I have to plug that hole in the code and restrict the report to only one specified date.
Any idea why I'm only seeing part of the report print out? Also, would it be helpful if I posted snippets (or whole chunks, whatever) of the code?
My apologies if this should be in the VBA/Modules section instead.
I've populated the detail_format and detail_print events with code that relies on the Print method and CurrentX/CurrentY placement to simulate my old report that was query-based. When I view the report in print preview mode, it's kosher. When I print from print preview mode, I only get 1 of 2 pages, and it's always the second page.
If I print from the database window w/out opening the report (right-click on the report and select "Print"), I get both pages and it looks perfect. The problem is that I've designed the database so that the users only interact with forms, not the database window. Also, I have to specify an "as of" date for the report to use, and I have to plug that hole in the code and restrict the report to only one specified date.
Any idea why I'm only seeing part of the report print out? Also, would it be helpful if I posted snippets (or whole chunks, whatever) of the code?
My apologies if this should be in the VBA/Modules section instead.
