473,396 Members | 1,940 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,396 software developers and data experts.

export report to .txt-file

2
Hi,

I have a MS-access database.
There is a report that i export (via a macro) to a .txt-file, the problem is that in each textfile is a empty line on top, which i don't get rit of...
Does anyone know a solution?
(i saw some threads on ithe internet of people who have the same problem, only answers i found where about how to get rit of empty lines between the lines of text, i had this also originally, now i only have one empty line on top of every textfile, it looks like this):
-------------------------

zerzaertarze
sdfgsd
dsfgdsfg
-------------------------
While it should be looking like this:
-------------------------
zerzaertarze
sdfgsd
dsfgdsfg
-------------------------

I hope someone knows the reason and solution!
It's driving me mad...

Thanks already!
fvd
Feb 5 '06 #1
3 4535
Niheel
2,460 Expert Mod 2GB
I can't find any built in solutions your problem.

I think the easier thing to do would be to create an app that will delete the first line of your apps.

Before you do that, check your database and see if you have an empty field somewhere. It would be the first field. I don't see why access would throw in an empty line.
Feb 5 '06 #2
fvd
2
No, there is no empty field.
The report and table are fine, only when you export it as a .txt-file a blanc line is being added, when i expor the same report as a .rtf-file there is NO empty line, so the reason lies not in the table or report.
Only the export to .txt goed wrong.
I don't know why...

If you have any ideas i would be very happy.
Thanks!
fvd
Feb 5 '06 #3
There is a fix...
The extra blank line at the top drove me insane! I happened to run the export on a different machine, however, and the line dissapeared - it's the printer driver. Set the printer to a generic one in the report page setup and it will go away.
Dec 15 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Vikrant | last post by:
Hey Friends I need to export an Access Report using a filter. I am using the method OutputTo m_pDoCmd->OutputTo( 3, // asOutputReport COleVariant(strReportName), // <report name>...
7
by: Pat | last post by:
I would like to send the Print Preview of a MS Access form to a Snapshot file. The form contains an OLE graph. BACKGROUND A snapshot of a report is possible. If I could I would use a report to...
1
by: Ganesh Bansal | last post by:
hi In C#, I am using CrystalRportViewer to show reports made using Crystal Report. Now, I need to export my reports to txt format while CrystalReportViewer allows only doc, pdf, rtf and some other...
1
by: John | last post by:
Hi. Sir: Does anyboday know how to export subreport data using the export button in crystal report tool bar? We have a main report including a on-demand report. When we click the on-demand...
0
by: David Valle | last post by:
Hi, i've follow an example that Gabriele G. Ponti wrote on 8/5/2003 about the export of a report made in Crystal Report in PDF format, this: ...
3
by: Brad | last post by:
In a Vista/IIS7 asp.net app, a coded crystal report export is crashing IIS7....but it works just fine in visual studio's cassini web server. And if I create a web form and use the crystal...
6
by: Liliputanac | last post by:
Hello. Is there a way to accomplish this from VB.NET 2005 ? thnx.
17
by: 1q2w3e4r5t6y7u8i | last post by:
Hi, I am printing an invoice through the following code: dim cr as new crystalreport1 cr.PrintToPrinter(1, False, 1, 1) the problem is that the complete paper cames out. I want to print...
3
by: Toby Gallier | last post by:
I am trying to figure out a way to update multiple records when a report is exported. Each record has a "Status" field. I have a query that selects all records with a status of "To Send" and that...
1
by: coolminded | last post by:
hello everybody, i have a viewer to view the report, but actually i wanted to export it in the txt format directly. i did: Report.ExportOptions.DestinationType = crEDTDiskFile ...
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
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
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
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...
0
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,...

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.