Ok - I'm new to VBA so bear with me
I have a REPORT that I need to export in a Tab delimited format.
The report has header rows and detail rows - starting with H and D respectivly.
As I have searched and tried to use:
DoCmd.transfertext acExportdelim, ,REPORT,C:\REPORT.txt
Everything talks about either TABLES or QUERIES. Can I use this type of command for Reports - are there any changes?
So far I have been umable to make it work and it hangs Acess.
Also - is this a Tab delimited format - or is some other delimiter used?
Thanks,
Jeb
I have a REPORT that I need to export in a Tab delimited format.
The report has header rows and detail rows - starting with H and D respectivly.
As I have searched and tried to use:
DoCmd.transfertext acExportdelim, ,REPORT,C:\REPORT.txt
Everything talks about either TABLES or QUERIES. Can I use this type of command for Reports - are there any changes?
So far I have been umable to make it work and it hangs Acess.
Also - is this a Tab delimited format - or is some other delimiter used?
Thanks,
Jeb