Exporting

[goslincm]

I am wondering if their is a way to export an access report in a format that will allow the recepiant to answer some questions directly on the report?

Our original thought with this report is that we want to email it as an attachment to some group members and ask them to add their comments in a couple of areas and return.

Thanks

 

[Shirley]

On a button click event try this code:

Private Sub cmdEvents_Click()

Dim stDocName As String

stDocName = "Nature Events"
DoCmd.SendObject acReport, stDocName
End Sub

It will send as an attachment to an email.

 

[goslincm]

Shirley, what is going to allow the user to be able to edit this report? It is still being sent as a rich text document, so I lose my signature lines for staff to sign above, I lose my boxes around certain yes/no questions.

Am I missing something?