When I export a Report to txt file, by default it is exported to 'User/My Documents' folder on C drive. For my application, I want the file to be exported to the same folder which contains the database. Is this possible ? I guess (and hope) it would be as simple as executing some code for relative path before the export; just don't know the code. Help appreciated and badly needed. Thanks.
How to change default export locaton for reports ?
- Thread starter Nilay
- Start date
- Local time
- Today, 04:55
- Joined
- Sep 12, 2006
- Messages
- 15,980
that location is currentproject.path
you can set the export to be saved to a file in that folder in code, when you use docmd.transfertext
you can set the export to be saved to a file in that folder in code, when you use docmd.transfertext
I'll require slightly detailed help. I'm not using docmd.transfertext but plain simple macro in Access 2010 (screenshot attached). (Can I export report with docmd.transfertext ? - on searching found that this has an argument 'tablename', so I presume that only tables can be exported by this). If you can paste a single line / few lines of code, I'll play with it and develop it further for my need. Thanks.
