Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-26-2010, 01:25 PM   #1
goni07
Newly Registered User
 
Join Date: Jan 2008
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
goni07 is on a distinguished road
How Can I Transfer report to txt file

I have make report but my printer print file just .inp or txt
how can I transfer from report to .txt or .inp


Last edited by boblarson; 11-26-2010 at 05:52 PM. Reason: fix typos
goni07 is offline   Reply With Quote
Old 11-26-2010, 04:11 PM   #2
John Big Booty
AWF VIP
 
John Big Booty's Avatar
 
Join Date: Aug 2005
Location: Planet 10, by way of the Eighth Dimension
Posts: 8,263
Thanks: 113
Thanked 1,011 Times in 865 Posts
John Big Booty is a jewel in the rough John Big Booty is a jewel in the rough John Big Booty is a jewel in the rough
Re: How Can I Transfer raport to txt file

Have a look at the DoDmd.OutputTo method, see also this link.

It's going to look something like;
Code:
DoCmd.OutputTo acOutputReport, "YourReportName, acFormatTXT, "YourOutPutFileName.txt"
__________________
...but they're only monkey boys!!!
John Big Booty is offline   Reply With Quote
Old 11-27-2010, 02:47 PM   #3
goni07
Newly Registered User
 
Join Date: Jan 2008
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
goni07 is on a distinguished road
Re: How Can I Transfer raport to txt file

thank you very much it funksionirt very good but I will this text file tu save in Folder
ex. filepath = "C:\Temp but i dont know how
can you help me how to save this text file
thank you

goni07 is offline   Reply With Quote
Old 11-28-2010, 04:29 PM   #4
John Big Booty
AWF VIP
 
John Big Booty's Avatar
 
Join Date: Aug 2005
Location: Planet 10, by way of the Eighth Dimension
Posts: 8,263
Thanks: 113
Thanked 1,011 Times in 865 Posts
John Big Booty is a jewel in the rough John Big Booty is a jewel in the rough John Big Booty is a jewel in the rough
Re: How Can I Transfer report to txt file

use;
Code:
DoCmd.OutputTo acOutputReport, "YourReportName", acFormatTXT, "C:\Temp\YourOutPutFileName.txt"
__________________
...but they're only monkey boys!!!
John Big Booty is offline   Reply With Quote
Old 11-29-2010, 01:01 AM   #5
goni07
Newly Registered User
 
Join Date: Jan 2008
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
goni07 is on a distinguished road
Re: How Can I Transfer report to txt file

thank you very much
it work excellent
thank

goni07 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfer CSV file with ado Wijklodewijk Modules & VBA 1 02-22-2008 09:38 AM
Automated file transfer candice General 2 01-17-2008 10:28 PM
Transfer Text File Name kidzmom3 Macros 2 09-11-2003 11:24 AM
Transfer Report to Txt File SteveM Reports 1 08-13-2002 04:34 AM
File Transfer guv Modules & VBA 0 08-04-2000 07:01 AM




All times are GMT -8. The time now is 11:51 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World