Snapshot Viewer

  • Thread starter Thread starter doodle
  • Start date Start date
D

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
 
doodle said:
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.
Click to expand...
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
Click to expand...

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

"Snapshot Format"

(including the quotes)
 
Back
Top