Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: AdrianLines
- Order by date
-
Creating individual page files from an access report.
The error message I am getting with this code is.. 'You tried to execute a query that does not include the specified expression [visits].[visitcompleteddate] as part of an aggregate function' This field is part of the report, but should be included within the select statement Visits.* !- AdrianLines
- Post #6
- Forum: Microsoft: Access Reports
-
Creating individual page files from an access report.
I've got a bit further today ! I've managed to create the output style I require using the Lebans library with a single table. I.e a PDF file per page with a filename generated from the primary index field. But now I'm stuck on the SQL Query format within the Recordset. The actual report I'm...- AdrianLines
- Post #5
- Forum: Microsoft: Access Reports
-
Creating individual page files from an access report.
Yes, I have looked at Lebans libraries, but it seems to work only on the complete reports, not individual pages. I was hoping it would create individual snapshots of each page first but it appears to do this in the library and not in the VB code.- AdrianLines
- Post #3
- Forum: Microsoft: Access Reports
-
Creating individual page files from an access report.
I've searched around for a solution but without much success. I need to be able to export to pdf/jpeg each page of a multipage report (where each page is an individual record), but I need to automate it so that the filename is created from the primary key field of each record. I have tried...- AdrianLines
- Thread
- Replies: 5
- Forum: Microsoft: Access Reports
