Reports

Cannot open any more tables
I've searched on this error and I'm not very clear on the solutions. Yes, I've created a very complex report with 16 subreports. And I get this error only when I try to print the report (even if I don't do a print preview first). Am I supposed to consolidate my queries (about 18 of them) into one super huge quer... 27 Jun 2008 23:26

Exporting Report to rtf on Different Users Machines Causes Different Outputs
Here's a quirk I just can't get my head around: We were just migrated from Office 2000 to Office 2003. We have an Access 2000 database (running in Access 2003) that has a variety of reports that we email (via SendObject coding) in an rtf attachment(s). For one particular report, I've created the .rtf file on... 11 Jul 2008 21:16

Using SourceDoc and/or SourceItem Properties
I have linked an Excel Spreadsheet in a Bound Object Frame to an Access Report. The report shows the actual spreadsheet. I want to show the Print/Preview of the spreadsheet. I think by using the SourceDoc and/or SourceItem properties I can return the print/preview of the spreadsheet. I don't want gridlines.... 27 Jun 2008 12:09

onprint at report level
I would like to have a print log to log when and who print the report and looking for a report level on print event. I just realikzed that on print event only exsits on detail level which I do not wnat to triggle every details on print. The event triggle even user preview the report. Are there any event trig... 27 Jun 2008 12:09

How to Print Repor on 11X14 and 11X17 Paer Size form Access 2007?
We create access reprot but we can not print paer size 11X14 or 11 X17. We need to be able to print or export report directly from Access 2007. Opetion not available. ... 27 Jun 2008 11:07

Query Time/Date Problem
Good Morning, I searched around and couldn't find another thread with this particular issue so here goes... I have a database where customers get logged in when they come into reception. I have name, phone#, visit#, what they came in for, and an ADATE to log the exact date and time they came in. I have a query th... 27 Jun 2008 11:07

Report
Sir, I made a quiry which contains the following fields Status On status I made a criteria "On Duty" Nationality On Nationality I made a Critera "Indian"Or"Filipino" and showing the result correctly My Question is in the Report I can count the total report by formula =Count(*) and also showing the ... 27 Jun 2008 11:07

VBA to output repor to PDF
I would like to output Access 2003 reports to PDF files using the full Adobe Acrobat 7 (I have it installed, and do not want to use Stephen Lebans reporttopdf technique). Does anyone have VBA to process the output and name the file? TIA ... 27 Jun 2008 08:02

Duplicated data in a report
Hi folks, I have re-read my earlier post asking for assistance with a report. It made no sense to me, so I'm not surprised that no-one replied. I'll have another go: We maintain a database where local firms offer work experience to pupils at our school. Once per year students choose three firms that they... 27 Jun 2008 12:09

New Version ConvertReportToPDF, Page Size Bug
Hello, I have been using Stephen's ConvertReportToPDF for some time and was thrilled to see an update on his site the other day. I was most excited about the "Fixed Paper Size Bugs." Alas, my bug is still around. Windows Server 2003 Enterprise 5.2 SP-2 Access 2000 9.0.6926 SP-3 I am able to export my repor... 30 Jun 2008 12:44