Problem With Textfile
Feb 4, 2006
Hi,
I have a report that i send with a e-mail (via a macro), the exported values of the report are send as a .txt-file.
Now something strange happens, between every 4 or 5 lines of text there is a blanc rule, this i want to get rit of!
So the textfile looks like:
qsdf
sdfg
dsfg
xcvb
xcvb
rty
rtye
ezrz
zerz
etc. etc.
When i send the report as a .rtf-file there are no blanc rules inbetween, so the problem lies not in the report itself i think.
But it needs to be send as a .txt file and not as a .rtf file, so if anyone knows the reason (or solution) i would be very happy!
Thanks already and kind regards,
fvd
View Replies
Nov 20, 2007
Beloved Access gurus,I am wondering if it's possible to export specific columns into certain positions in the textfile? I haven't seen this done with Access before so i dont know. I have an access table that i would like exported periodically into a textfile (meaning, i have to do this with vba).For example - loop through table, exporting into textfile:column 1 ---> start on 1st line Position 20 in the text file (after 19 spaces)column 2 ---> beginning of next line.column 3 ---> back to previous line, position 40.Is this possible? If so, any thoughts or suggestions will be greatly appreciated.
View 9 Replies
View Related
Jun 6, 2006
Hi All,
I have this line of code:
DoCmd.TransferText acExportDelim, "Dhcp Specification", "tblDHCP", "U:" & [Forms]![frmExportDHCP]![cmbServer] & ".txt", False, "", 850
Where the section highlighted is a combo box on a form. I was trying to use the value in this combo box to describe the filename of the text file I was exporting to. However I get the error:
The Microsoft Jet Databse Engine could not fond the object 'X#txt'. Make sure the object exists and the you spell it name and path name coreectly.
Where X is the string stored in the combo box.
Any ideas where I have gone wrong/what could be improved?
Cheers,
Matt
View 1 Replies
View Related
