Results 1 to 5 of 5

Thread: DoCmd.OutputTo works in .adp file but not .accdb file

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    May 2015
    Posts
    87
    Location

    DoCmd.OutputTo works in .adp file but not .accdb file

    I am rebuilding a database as a .accdb file instead of .adp file so it will work in Access 2013 and I get a Property not found error on this line trying to transfer results from a view into an excel file. This code works in the .adp file.

    'Export the open issues query results (created view in SQL server)
    [CODE][CODE]DoCmd.OutputTo acOutputServerView, "dbo.Issue Open 3", "ExcelWorkbook(*.xlsx)", "I:\Groups\ccuser\Finance\Collection Control\Open Issues\OpenIssuesReport.xlsx", False, "", , acExportQualityPrint
    Last edited by cleteh; 04-25-2017 at 01:17 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
  •