Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting Report Question..??

Status
Not open for further replies.

WB786

MIS
Mar 14, 2002
610
I am exporting a report to be emailed and using the acFormatSNP which works fine except that for the attachment name it says qry_ReportName.SNP. How could I make it so that the report attachement name could be little bit more meaningful for my client. I don't want the name to say qry_. Anyone has any idea on this??? Thanks in advance.

:)WB
 
What method are you using to Export it? Do you have the code you can post.

Paul
 
Here is the coding for my on click event button.

Dim stDocName As String

stDocName = "SPLetter"
DoCmd.SendObject acReport, stDocName, acFormatSNP, , , , "Your Account Information."
 
Ok nevermind, figured it out. Name the report correctly in the properties. My brian was on a long break from programming. Thanks for replying though.

:)WB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top