Full Version: Saving first 2 pages of a report in Snapshot format
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
Berty
Apr 9 2006, 03:38 PM
Hi Guys

I'm trying to e-mail specific pages of a report to colleagues in snapshot format

The e-mailing bit is fine (once I have my report saved) - here's that bit of code:
CODE
DoCmd.SendObject acSendReport, "Dealer Composite Analysis", "Snapshot Format", _
    "", , _
    , My subject here", "My message here"


My problem is that I can't figure out how to create a snapshot of just say pages 1 and 2 or say pages 10 - 15 of a report called RptDealerComparison.

Am I asking too much? - please help if you can


Regards


John
kamle_b
May 23 2006, 03:11 AM
Doubt it if that can be done. I think you will have to produce different reports for the pages you want snapshot format of.

What i usually do is describe the report name as string

CODE
Dim stDocName As String

    stDocName = "Dealer composite analysis"
    
   DoCmd.SendObject acReport, stDocName, acFormatSNP, "name@domain.com", "", "", "Trail"


Now if you know how to divide this string for particular pages then you can achieve what you want. For me, i tried different things but couldnt achieve.

Regards,
Kamle
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.