Hi,
I'm trying to write a simple line of code to export a record in my query using DoCmd.TransferText acExportDelim. Only i'm having problems with the specifications.
Everywhere I go it tells me that in order to do this I need to do a manual export and click advanced on the wizard and save the specification. But there is no advanced button in my wizard....??
At the end it asks me if I want to save the steps so I do, then I try and call this in the code, but it says the specification cannot be found. I doubt that's meant to work but i'm clutching at straws as I can't follow anyones instructions as i have no Advanced button.
Any help? i'm using access 2007.
Thanks
I'm trying to write a simple line of code to export a record in my query using DoCmd.TransferText acExportDelim. Only i'm having problems with the specifications.
Everywhere I go it tells me that in order to do this I need to do a manual export and click advanced on the wizard and save the specification. But there is no advanced button in my wizard....??
At the end it asks me if I want to save the steps so I do, then I try and call this in the code, but it says the specification cannot be found. I doubt that's meant to work but i'm clutching at straws as I can't follow anyones instructions as i have no Advanced button.
Any help? i'm using access 2007.
Thanks