473,387 Members | 1,548 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Access 2000 SendObject "Report" problems

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 13 '05 #1
1 1911
"Tom Louchbaum" <tw*@uwm.edu> wrote in message
news:41***************@uwm.edu...
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.


The export to RTF utility is crap. Always has been. It will not be
reliable for anything but the simplest of tabular data. Use Snapshot
Format or create a PDF file instead.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: P K | last post by:
Hi, I have an MS Access report which consists of Multiple subreports, when i export the report to MS RTF format in few cases it leaves a Big blank space on the sheet which is like 6 inches...
1
by: mar10a | last post by:
I am trying to insert a .gif. file into an Access report - using Insert Picture. The original image is 8X11, but access changes the size to 4X6.5. When I change the size of the image in access...
0
by: Bob Alston | last post by:
I am having trouble on a client PC getting the Office link, to send an access report I am viewing to MS Word. Also I cannot get send to - mail recipient to work either. The command box pops up...
4
by: vbie | last post by:
For some reason, I cannot open an Access report in "design" mode anymore. This didn't happen before. However, I can open the design mode of the form, query, table in the same database. Please...
2
by: collegekid | last post by:
Hi everyone, basically my problem is this: I am using an Access 2000 format. And--I have four subforms in my main form. (Purpose of this is to track projects.) So in my main form I enter the...
6
by: DeniseY | last post by:
I have an Access report that is created on the fly by the user selecting the fields to be included. The Access report comes out fine, but I want it to automatically output to an Excel spreadsheet....
2
by: Composer | last post by:
This is not a question but rather an answer, or at least a clue. Like others, I had experienced seemingly random truncation of text when exporting a perfectly good Access report to RTF. Or...
2
by: Adel2007 | last post by:
Hi everyone, I have installed Stephan Leban's code to create a text box with a justified text in Access Report. This worked perfectly well. However, I need your help with regards to 2 problems: 1-...
10
by: Dan2kx | last post by:
Hello to all, i have a new interesting problem to solve.... i have a report that i would like to email to a list of users, the report is a full page document and is personalised to each user...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
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,...
0
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...

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.