Results 1 to 3 of 3
  1. #1
    a14guguliye is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    6

    RunTime error 3201

    Dear Team


    I have been struggling to output the PDF report to the relevant folder within the server. The error which is showing is

    RunTime error 3201, no record found.

    Could you please help me to solve it?
    Dim RFQNumber As String
    Dim InNumber As String
    Dim FullReportName As String
    Dim path1 As String

    RFQNumber = [Forms]![RFQ_Database]![RFQ_ExNumber]
    InNumber = [Forms]![RFQ_Database]![RFQ_InNumber]
    path1 = "\\AZBAK-FP02\Work\Old Server Data\V&C" & RFQNumber & "" & RFQNumber & " " & InNumber & ".pdf"

    MsgBox (path1)

    DoCmd.OutputTo acOutputReport, "AOrderFCAVienna", "PDFFormat(*.pdf)", path1, False

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    I think the outputTo parameter is: acFormatPDF

    pressing spacebar comma,after the parameter column,will show you the options you can pick from.

  3. #3
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,115
    You are missing a space in the value for the format type, the value for acFormatPDF is "PDF Format (*.pdf)"

    https://answers.microsoft.com/en-us/...a-8b6a15652025

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Recordset not found Error 3201
    By Thompyt in forum Programming
    Replies: 5
    Last Post: 01-15-2019, 03:23 PM
  2. Error 3201
    By JennyL in forum Access
    Replies: 11
    Last Post: 06-15-2018, 11:14 AM
  3. Replies: 5
    Last Post: 04-02-2017, 04:55 PM
  4. Error Handeling for a 3201 and 3022 Error
    By starlancer805 in forum Access
    Replies: 3
    Last Post: 03-11-2015, 12:46 PM
  5. Error 3201 on Form / Subform
    By jerem in forum Programming
    Replies: 2
    Last Post: 12-01-2012, 12:34 AM

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