473,883 Members | 1,635 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Report Print Event and Docmd.Sendobjec t

When I preview my Access 2000 Report it looks fine. When I Email the
report using

DoCmd.SendObjec t 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
5 5834
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*********@hot mail.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.SendObjec t 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
-----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:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBP/oQxYechKqOuFEgE QIouwCgjpPrrH4z lOKHHTmANZhpcbd dUasAniya
sdWjQYFN62oZauo YAIIj/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.SendObjec t 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
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.SendObjec t 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

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
-----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:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBP/uNSIechKqOuFEgE QJtnwCePEHs7iPP LFW2SywH30mtS8Z rN90AoMah
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
23886
by: Nicola | last post by:
Hi Everyone, I am new to programming and would like to know how to open an access Report from within vb 6. I am trying to write a program to organise cross stitch threads. I have found out how to use a database table but all I want to do now is to click a command button to display this access report. Any suggestions please ?????
3
4354
by: jdph40 | last post by:
I'm using Access 97. In the OnClick event of a button I have the code below. I looks at txtEmail and sends an e-mail message without further action from the user (user does not have to click Send as he would if he used DoCmd.SendObject.) However, I want to attach a report in Snapshot format. How would I modify my code to include a report? Thank you, JD
7
8384
by: Nothing | last post by:
I have a report based on a query that is based agaisnt two tables. The report pulls information for 1 customer. The tables may hold multipul customers. I want to email just the ONE report. All the options that I have found to email a report email multipul pages of the report, i.e. it sends all the information it can get fomr the query results. I am triggering the report via VBA off of a form. There is a button that
1
1947
by: Tom Louchbaum | last post by:
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
2
4356
by: Filips Benoit | last post by:
Dear All, SendObject has no where-argument! How can i email a report having user-defined filter, without opening the report? On a unbound form the user can set the criteria for a report. The where-argument is set depending the user choice. He can output the report as preview, print or email.
4
3623
by: Tim Marshall | last post by:
The report indicated in the send object command below has various colours in it which show nicely when the report is previewed and printed. However, when sent as an attachment to users without Access as per the statement below, no colours are displyed: DoCmd.SendObject acSendReport, "rptSideDetails", acFormatHTML, _ Me.txtAddress, "", , Me.txtSubject, Me.txtBody, -1 I would dearly love to have colours showing in an exported Html...
2
2859
by: airdata | last post by:
Hi I currently have the following code attached to a command button on a switchboard form. This is basic Access 2000. Private Sub Print_daily_reports_button_Click() On Error GoTo NoData DoCmd.OpenReport "Sales Return (TODAY)", acViewNormal DoCmd.OpenReport "Sales/Collections (TODAY)", acViewNormal
12
3555
by: Studiotyphoon | last post by:
Hi, I have report which I need to print 3 times, but would like to have the following headings Customer Copy - Print 1 Accounts Copy - Print 2 File Copy -Print 3 I created a macro to print the report three times, but do not know how
1
2611
by: didacticone | last post by:
i have a database where i am trying to email a report as an attachment, it works fine but since it is an .rtf file the conversion is messy... i was wondering if i can do it as a pdf or some other easily read file... any help is greatly appreciated. thanks.. here is my current code.. and also some info on the report is populated by the current record i am on in the form... On Error GoTo cmdEMailReport_Click_Err Dim strMsg As String,...
0
9933
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
11114
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10730
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10835
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10407
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9563
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7114
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
4205
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3230
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.