Results 1 to 3 of 3
  1. #1
    thegrimmerdiscovery is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2017
    Posts
    30

    Saved Export from command button

    People




    I'm trying to run my saved export 'ExpQuarterlyReport' from a form command button.

    I've added
    DoCmd.RunSavedImportExport "ExpQuarterlyReport" into the button onclick but Access reports an error of not finding the object DoCmd.

    WHere am i going wrong with this? I've seen others online saying this has worked for them.

    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    DoCmd.RunSavedImportExport "name", is correct IF that is the name of the Export.

    if this is a query, you can also use:
    docmd.Transferspreadsheet
    or
    docmd.outputTo

  3. #3
    thegrimmerdiscovery is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2017
    Posts
    30
    Thanks Ranman

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

Similar Threads

  1. Replies: 4
    Last Post: 09-05-2016, 10:27 AM
  2. command button to export to excel
    By jains in forum Forms
    Replies: 5
    Last Post: 06-30-2015, 06:27 PM
  3. Replies: 2
    Last Post: 01-29-2013, 07:01 PM
  4. Replies: 0
    Last Post: 03-24-2011, 09:59 AM
  5. Export Command Button in Form
    By jjmartinson in forum Forms
    Replies: 3
    Last Post: 08-25-2009, 01:28 AM

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