Results 1 to 4 of 4
  1. #1
    Techno is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2023
    Posts
    31

    DoCmd.OpenReport start printing the report in PDF, Excel needed


    Hello,

    When I try to open a report with DoCmd.OpenReport ("Report Name"), it automatically starts to print the PDF format of the report.
    I need that report in excel format so that it can be saved when the code opens the report, how it can be achieved? Thanks in advance for any help.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    Looks like you need additional parameters- see this link
    https://learn.microsoft.com/en-us/of...Cmd.OpenReport

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    Looks like you need additional parameters- see this link
    https://learn.microsoft.com/en-us/of...Cmd.OpenReport

    also investigate https://learn.microsoft.com/en-us/of...docmd.outputto

  4. #4
    Techno is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2023
    Posts
    31
    Thank you...

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

Similar Threads

  1. Replies: 3
    Last Post: 08-28-2016, 03:52 PM
  2. Replies: 4
    Last Post: 10-18-2015, 11:50 AM
  3. Replies: 2
    Last Post: 07-15-2014, 07:22 PM
  4. DoCmd.OpenReport WHERE condition
    By bidbud68 in forum Programming
    Replies: 16
    Last Post: 10-19-2012, 05:31 AM
  5. Need help w/ docmd.openreport
    By jwill in forum Reports
    Replies: 3
    Last Post: 06-04-2012, 09:49 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