Results 1 to 4 of 4
  1. #1
    keiths is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Apr 2017
    Posts
    2

    Updating function inside a module

    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.

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Did you change your export specification?

  3. #3
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    It is as aytee said the export specification. Happened to me last week!!


    Sent from my iPhone using Tapatalk

  4. #4
    keiths is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Apr 2017
    Posts
    2
    Thank you. That fixed the problem. It is working fine now. I knew it would be simple. I need to really dig into the Module side and learn it.

    Thanks again.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 05-19-2015, 08:41 AM
  2. Help with DCOUNT Function in Module
    By qcjustin in forum Access
    Replies: 9
    Last Post: 04-08-2015, 09:54 AM
  3. Replies: 0
    Last Post: 03-17-2011, 09:57 AM
  4. Calling A Module Function To Open A Form
    By orcinus in forum Modules
    Replies: 3
    Last Post: 09-29-2010, 04:43 PM
  5. Replies: 3
    Last Post: 08-13-2010, 11:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums