By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,497 Members | 2,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,497 IT Pros & Developers. It's quick & easy.

Report Print Event and Docmd.Sendobject

P: n/a
When I preview my Access 2000 Report it looks fine. When I Email the
report using

DoCmd.SendObject acSendReport, "Report", acFormatRTF, "To Address", , ,
"Subject", , False

the resulting attachment to the email consistently does not display all
of the lines it should in one of the GroupFooters. I am using the Print
event in the report to print lines multiple times in a groupfooter
depending on an integer set elsewhere in the VBA code. It does however
leave the appropriate number of lines, it just doesn't print all of the
data it should on those lines.

Help?

Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
If you really, really want to retain all the Access formatting, you
need to output it as a snapshot file ... acFormatSNP
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"Tom Louchbaum" <tw*@uwm.edu> wrote ...
When I preview my Access 2000 Report it looks fine. When I Email the
report using

DoCmd.SendObject acSendReport, "Report", acFormatRTF, "To Address", , ,
"Subject", , False

the resulting attachment to the email consistently does not display all
of the lines it should in one of the GroupFooters. I am using the Print
event in the report to print lines multiple times in a groupfooter
depending on an integer set elsewhere in the VBA code. It does however
leave the appropriate number of lines, it just doesn't print all of the
data it should on those lines.

Help?

Nov 12 '05 #2

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not sure what you're saying - a line is a graphical object (i.e., a
solid line not a line of alphanumeric characers). If that is what
you're talking about, then - when reports are sent thru email they are
transformed into RTF files. RTF files remove all graphical objects.

HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP/oQxYechKqOuFEgEQIouwCgjpPrrH4zlOKHHTmANZhpcbddUasA niya
sdWjQYFN62oZauoYAIIj/Iz/
=uijw
-----END PGP SIGNATURE-----
Tom Louchbaum wrote:
When I preview my Access 2000 Report it looks fine. When I Email the
report using

DoCmd.SendObject acSendReport, "Report", acFormatRTF, "To Address", , ,
"Subject", , False

the resulting attachment to the email consistently does not display all
of the lines it should in one of the GroupFooters. I am using the Print
event in the report to print lines multiple times in a groupfooter
depending on an integer set elsewhere in the VBA code. It does however
leave the appropriate number of lines, it just doesn't print all of the
data it should on those lines.

Help?


Nov 12 '05 #3

P: n/a
Actually I am aware that RTF files do not perserve graphics from
Access Report files. This is very unfortunate for my project. There
are no graphics in the Report object I referred to in my original
posting. I realize I could use a SNP file but I'd rather not for other
reasons.

The items that should be printed, and are not, in the resulting RTF
file, are underscores which are acsii characters (shift -). Some appear but
many do not. Only the first few of those that are supposed to be printed in
the Group Footer are
printed, the rest are replaced with blank spaces. The Group Footer
has a Print Event which created these output lines by making
certain items Visible or not Visible and looping thru a DO loop.

When I preview the report object in ACCESS it is fine but the RTF
file created as a result of the SENDOBJECT is where the problem
occurs.

I could still use help -- please?!
MGFoster wrote:

Not sure what you're saying - a line is a graphical object (i.e., a
solid line not a line of alphanumeric characers). If that is what
you're talking about, then - when reports are sent thru email they are
transformed into RTF files. RTF files remove all graphical objects.
Tom Louchbaum wrote:
When I preview my Access 2000 Report it looks fine. When I Email the
report using

DoCmd.SendObject acSendReport, "Report", acFormatRTF, "To Address", , ,
"Subject", , False

the resulting attachment to the email consistently does not display all
of the lines it should in one of the GroupFooters. I am using the Print
event in the report to print lines multiple times in a groupfooter
depending on an integer set elsewhere in the VBA code. It does however
leave the appropriate number of lines, it just doesn't print all of the
data it should on those lines.

Help?


Nov 12 '05 #4

P: n/a

Actually I am aware that RTF files do not perserve graphics from Access
Report files. This is very unfortunate for my project. There are no
graphics in the Report object I referred to in my original posting. I
realixe I could use a SNP file but I'd rather not for other reasons.

The items that should be printed, and are not, in the resulting RTF file
are underscores. Some appear but many do not. Only the first few of
those that are supposed to be printed in the Group Footer are printed,
the rest are replaced with blank spaces. The Group Footer has a Print
Event which created these outoput lines by making certain items Visible
or not Visible and looping thru a DO loop.

When I preview the report objec in ACCESS it is fine but the RTF file
created as a result of the SENDOBJECT is where the problem occurs.

I could still use help -- please?!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #5

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi again,

I now remember I had this same problem w/ a project I worked on about
3 yrs ago. The dashes (not a graphical line) were disappearing after
80 were printed (horizontally), when printed as Word/RTF files. The
only solution we could find, IIRC, was to narrow the width of the
report so 80 dashes were adequate to the purpose. IOW, we couldn't
solve the disappearing dashes problem, we had to kludge a work-around.

You might want to try the footer's OnFormat event procedure to display
the underline chars.

HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP/uNSIechKqOuFEgEQJtnwCePEHs7iPPLFW2SywH30mtS8ZrN90A oMah
WEoxT0MXN+FQvjA+iMfNVyKp
=EIi8
-----END PGP SIGNATURE-----
Tom Louchbaum wrote:
Actually I am aware that RTF files do not perserve graphics from
Access Report files. This is very unfortunate for my project. There
are no graphics in the Report object I referred to in my original
posting. I realize I could use a SNP file but I'd rather not for other
reasons.

The items that should be printed, and are not, in the resulting RTF
file, are underscores which are acsii characters (shift -). Some appear but
many do not. Only the first few of those that are supposed to be printed in
the Group Footer are
printed, the rest are replaced with blank spaces. The Group Footer
has a Print Event which created these output lines by making
certain items Visible or not Visible and looping thru a DO loop.

When I preview the report object in ACCESS it is fine but the RTF
file created as a result of the SENDOBJECT is where the problem
occurs.

I could still use help -- please?!
MGFoster wrote:

Not sure what you're saying - a line is a graphical object (i.e., a
solid line not a line of alphanumeric characers). If that is what
you're talking about, then - when reports are sent thru email they are
transformed into RTF files. RTF files remove all graphical objects.

< snip first post >

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.