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? 1 1940
"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.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.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 length, when i try to move my
cursor there,it will not allow me to move the cursor in that blank
space.
I noticed this problem appears only when the subreport has values which
goes beyond one sheet. Even when i try using the Publish to Word button
|
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 is puts white border
around it and does not change the actual image.
Is there a setting I need to change that would allow access to import
at the correct size, or do I need to use another file type besides
|
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 as usual but just hangs and never completes.
On my home Win xp Office 2003 it works just fine.
My client has Win XP and Office 2002.
|
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 advise.
|
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 project name, one primary point person for it (1:N list from a separate table), other details, and a manually entered tracking number, which is the primary key.
Now, I also need to put down the legal entities, business managers, financial...
| |
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. Again, I have this part working. But the fields in the resulting spreadsheet are in a different order than the Access report. (Example: The fields in the Access report might go FirstName, LastName,Address,City--in the Excel spreadsheet, they come up...
|
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 rather, one
person experienced it when another didn't, running the same database
on the same computer, both accessing it via Remote Desktop Connection.
This problem made no sense until we found that we had different screen
resolutions, and that when...
|
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- the new text box (which has the justified text) does not allow me to make it grow and shrink to suit my text.
2- also the box doesn't read Arabic text. It shows the letter as question marks.
I am using Access 2002, on a Windows XP.
I would be...
|
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 (basically) more than one user can have the same email address so i will create a recordset to list all of the users (who need the email) and loop through the users and send to the associated email address, i have a few problems
1)currently the...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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...
| |
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |