Snapshot Viewer

[doodle]

I give up.

oops. I meant to post this as a new message.


greetings all. i have looked through the archives and can find no
solution. Someone please tell me I spelled something wrong, becuase I
cannot figure out why this code is not working.


Access 97
Windows xp
Lotus Notes


The email comes up fine, but it is still prompting the user for the
format type, even after I specified snapshot.


Thanks in advance,


doodle


here is my code: (one case of many in the select)


Select Case cmdReport
Case "Job Log Target Summary By Month"
DoCmd.SendObject ObjectType:=acReport,
ObjectName:="rpt_JobLog_Target_Chart", _
OutputFormat:=acFormatSNP, Subject:=strSubject,
MessageText:=strMessage

 

[Rick Brandt]

greetings all. i have looked through the archives and can find no
solution. Someone please tell me I spelled something wrong, becuase I
cannot figure out why this code is not working.

Access 97
Windows xp
Lotus Notes

The email comes up fine, but it is still prompting the user for the
format type, even after I specified snapshot.

here is my code: (one case of many in the select)

Select Case cmdReport
Case "Job Log Target Summary By Month"
DoCmd.SendObject ObjectType:=acReport,
ObjectName:="rpt_JobLog_Target_Chart", _
OutputFormat:=acFormatSNP, Subject:=strSubject,
MessageText:=strMessage

The named constant acFormatSNP was not introduced until after Access 97. In
Access 97 use...

"Snapshot Format"

(including the quotes)

 

[doodle]

thanks rick.

-adria