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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date/time data type mismatch in sql using access
Here is my syntax: SELECT ListingsTable.PubID, Count(ListingsTable.ListingID) AS CountOfListingID, ListingsTable.Agent, ListingsTable.OfficeCode, ListingsTable.Company, ListingsTable.[CompPhn#], ListingsTable.ListDate FROM ListingsTable GROUP BY ListingsTable.PubID, ListingsTable.Agent...- cpdjimmy
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
-
How to specify pages to print in acviewnormal mode
I meant i have it currently as: DoCmd.OpenReport "CPDReport", acViewPreview, "", "[DISCLOSURE_TABLE]![ID]=[Forms]![DISCLOSURE_ENTRY_FORM]![ID]" DoCmd.SelectObject acReport, "CPDReport" DoCmd.PrintOut acPages, 2, 15, acMedium...- cpdjimmy
- Post #2
- Forum: Microsoft: Access Reports
-
How to specify pages to print in acviewnormal mode
How do i specify certain pages to print using the normal view?? heres what i have that works but it always load up a preview of the report to print which takes too long DoCmd.OpenReport "CPDReport", acViewNormal, ""...- cpdjimmy
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
