DoCmd.SendObject acSendReport

  • Thread starter Thread starter JethroUK
  • Start date Start date
J

JethroUK

On Error Resume Next
DoCmd.SendObject acSendReport, "STATS", acFormatRTF,
"(e-mail address removed)", , , "Please Find Stats"

Send obj creates an email with a report attached - fine - i can send it -
fine
If I dont 'send' the email (whilst i'm testing, and it is going to happen)
and cancel it - Access generates error "you've quit a VB Process by closing
the object...." & hangs up - I have to kill the whole application

Included On Error command to no avail

Any clues?
 
Works fine now I have changed the for from popup to normal - it was behaving
like 'modal' form albeit it wasn't modal
 
Back
Top