theConjurian
IS-IT--Management
DoCmd.OpenReport "Booking Information", acViewPreview, wherecondition:=strWhereCond
DoCmd.SendObject acSendReport, "Booking Information", acFormatHTML, strAddress, , , _
"Booking Information", strMessage, True
DoCmd.Close acReport, "Booking Information"
In the code fragment above, the message
"Can't find the field 'Forms' referred to in your expression"
comes up as it executes the SendObject statement. This stopped working when I changed a graphics element in the report (which is why I changed it in the first place!)
Can anyone suggest why this might be happening?
On a related note, the graphical element gets stripped out of the email version of the report. What can I do to get it to appear? Someone suggested that it had something to do with the conversion to Windows Metafile prior to sending.
DoCmd.SendObject acSendReport, "Booking Information", acFormatHTML, strAddress, , , _
"Booking Information", strMessage, True
DoCmd.Close acReport, "Booking Information"
In the code fragment above, the message
"Can't find the field 'Forms' referred to in your expression"
comes up as it executes the SendObject statement. This stopped working when I changed a graphics element in the report (which is why I changed it in the first place!)
Can anyone suggest why this might be happening?
On a related note, the graphical element gets stripped out of the email version of the report. What can I do to get it to appear? Someone suggested that it had something to do with the conversion to Windows Metafile prior to sending.