UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Saving first 2 pages of a report in Snapshot format    
 
   
Berty
post Apr 9 2006, 03:38 PM
Post #1

UtterAccess Guru
Posts: 633
From: Gloucester UK
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
Go to the top of the page
 
+
kamle_b
post May 23 2006, 03:11 AM
Post #2

UtterAccess Addict
Posts: 174
From: UK
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
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 07:05 AM