Results 1 to 4 of 4
  1. #1
    rdougherty is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Location
    Michigan
    Posts
    91

    error message from Access 2016 & Win10 user - 2046 OutputTo isnot available now


    After solving the issue in the below thread (different error, so thought it should be new thread), the user is then receiving a new error message:

    https://www.accessforums.net/showthread.php?t=64212

    "The command or action 'OutputTo' isn't available now. 2046"

    I suspect, due to the wording "outputTo" that it is referring to one of the lines of code like:

    Code:
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12
    (irrelevant portions of code removed for brevity)

    Anyone know how to solve for this?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Try it in a macro.

  3. #3
    rdougherty is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Location
    Michigan
    Posts
    91
    Thanks for the suggestion... but may I ask why this would be necessary? Or, are you simply suggesting this as a troubleshooting step and not as a workaround?

    EDIT:
    I have found some discussion elsewhere stating that it has something to do with having the database window hidden (which is true for my user as well. - note, just tried on my 2010 version (win7) which works okay )
    https://www.experts-exchange.com/que...wer25088339-20

    I do not pretend to understand exactly what this user is suggesting as a solution... would it work in my case?

    Do I need to have each Win10 Ac2016 user first change a setting in Access to let them export data when their db window is hidden? (they don't need to see all the dev goodies when performing these tasks...)

    EDIT2:
    http://www.utteraccess.com/forum/ind...wtopic=2035785

  4. #4
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Looking for more errors.
    transferspreadsheet shouldn't give outputTo errors.

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

Similar Threads

  1. Replies: 0
    Last Post: 09-10-2016, 11:55 AM
  2. Replies: 5
    Last Post: 01-18-2016, 09:23 AM
  3. Standalone Access licence post Win10 Update
    By MoodyPD in forum Access
    Replies: 0
    Last Post: 01-07-2016, 01:39 PM
  4. Replies: 4
    Last Post: 12-12-2014, 08:48 AM
  5. Run-time error 2046
    By Evans2 in forum Forms
    Replies: 8
    Last Post: 09-06-2014, 01:52 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