Results 1 to 3 of 3
  1. #1
    DannyDont is offline Novice
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Location
    Harrison, MI
    Posts
    16

    Run SavedImportExport not working in Macro

    I have built and saved and Export Specification to export query information to a text file. When I run the Specification from the Saved Exports List it works just fine. When I build a Macro and attempt to run it, it does NOT work. ?????
    Click image for larger version. 

Name:	ExportMacro.PNG 
Views:	10 
Size:	4.6 KB 
ID:	23528

    The "ExportThisDamnThing" runs a query and creates a text file with no field "qualifiers" but separated by [,]s. I have created four or five different Export Specifications, all work when executed from the Saved Exports list, none work in a Macro. I want to use the Macro so that it may be executed by an On-Click event for a Button. I have searched the Internet until I am exhausted.

    I am not sure, but I believe that I have attached the text file that is generated by the Export Specification when run from the Saved Exports list, NOT in a Macro as it does not work.

    If the file is not attached, it looks like; Field1,Field2,Field3,Field4, ... ,Fieldnn - There are not quotes ["]



    Thanks for your help.
    DannyDont (Dan)
    Last edited by DannyDont; 01-29-2016 at 09:54 AM.

  2. #2
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    While I can't help you with this I suggest taking that attached file off and upload one with dummy data. Those 159 families wouldn't be happy to see their sensitive data online

  3. #3
    DannyDont is offline Novice
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Location
    Harrison, MI
    Posts
    16
    Thank you for the suggestion. I have removed the file. The example that I gave in my original post will need to do.

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

Similar Threads

  1. Replies: 1
    Last Post: 01-21-2015, 02:02 PM
  2. Macro to VBA not working?
    By mgio in forum Programming
    Replies: 5
    Last Post: 07-16-2014, 02:01 PM
  3. Data Macro's not working... please help
    By MFriend in forum Access
    Replies: 4
    Last Post: 06-02-2014, 03:00 PM
  4. Replies: 7
    Last Post: 08-10-2012, 03:09 PM
  5. RunCode in macro not working
    By LilMissAttack in forum Access
    Replies: 0
    Last Post: 05-27-2010, 05:01 PM

Tags for this Thread

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