Hello. I have been an Access user for quite a while, however, have not used Modules to any extent. I have a Module written in Access 2013 that creates a text file to export to another database, using the command inside the function,
DoCmd.TransferText acExportFixed, "CAFM9_Export3QueryR5 Export Specification", "CAFM9_Export3QueryR5", filename
I had to add another field in the CAFM9_Export3QueryR5 query. The query runs fine with the new field added. However, when I run the Module, the text file created does not have the new field.
I am sure there is a simple answer to this, however, I cannot find it by using Google. Could someone please tell me how do I get the function to recognize the new updated query and have it create the correct text file whenever it is run?
Thanks so much and please let me know if I am not explaining this properly or if I made a mistake. I appreciate the help.