Tags: access, acformatrtf, acsendreport, address, database, docmdsendobject, email, error, microsoft, ms-access, mysql, nextdocmd, oracle, questionfor, resume, sendobject, sql, stats

DoCmd.SendObject acSendReport

On Database » Microsoft Access

1,372 words with 1 Comments; publish: Fri, 06 Jun 2008 12:25:00 GMT; (250109.38, « »)

On Error Resume Next

DoCmd.SendObject acSendReport, "STATS", acFormatRTF,

"address.ms-access.questionfor.info.email.com", , , "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?

All Comments

Leave a comment...

  • 1 Comments
    • Works fine now I have changed the for from popup to normal - it was behaving

      like 'modal' form albeit it wasn't modal

      "JethroUK" <reply.ms-access.questionfor.info.the.board> wrote in message

      news:%23xHgLp07FHA.1184.ms-access.questionfor.info.TK2MSFTNGP12.phx.gbl...

      > On Error Resume Next

      > DoCmd.SendObject acSendReport, "STATS", acFormatRTF,

      > "address.ms-access.questionfor.info.email.com", , , "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?

      >

      #1; Fri, 06 Jun 2008 12:26:00 GMT