Results 1 to 7 of 7
  1. #1
    Ddempsii is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    24

    Exporting PDF


    Hello all,

    Hope all is well, I've been beating my head against the wall for a little bit now. What I have is a form that on save, exports a pdf of the form into the selected folder. I'm getting into navigation forms (which look way better than what i'm doing) and I can't seem to export the pdf. I'm assuming its because now the form is considered a subform. So how do you export a pdf of a subform?

    DoCmd.OutputTo acOutputForm, "MyFormName", acFormatPDF, NameofFileAD, False, , , acExportQualityScreen

    This is what i'm current using, obviously not "MyFormName" but I've tried "Form.subform" and other things. From the above the pdf does get generated BUT the entire pdf is a blank white pdf.

    Please let me know if anyone has any idea, or if you need more detail. Thank you!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    did you try with only these params:
    DoCmd.OutputTo acOutputForm, "MyFormName", acFormatPDF, NameofFileAD

    is your form very large?
    sometimes it creates multiple pages.

  3. #3
    Ddempsii is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    24
    Just did, it creates the pdf file (1 pg) but when opened its all white, just blank.

    The form is not even a full 2 pages long. 1 1/2.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    I will tell you right now that I avoid Navigation Forms/Controls like restaurants my ex's visit.

    You may be able to reference the form within the control by doing something similar to the following ...
    [Forms]![mainform]![NavigationSubform].[Form]

    There are probably 2 or 3 helpful references out there. I was able to get some insight using a post Steve created
    https://www.accessforums.net/showthr...820#post310820

  5. #5
    Ddempsii is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    24
    You avoid them? I'm interested to understand why. They look very clean and user friendly. This is my first time using nav forms but if this isn't the way to go let me know.

    I tried [Forms]![mainform]![NavigationSubform].[Form] using my main form name and all I got was an error.

    Thank you for the link and the response ill look into it a little more.

  6. #6
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Because of the pain you are experiencing today, I avoid them. I do not avoid them because they are ugly. I believe it is possible to pass the fully qualified name using the Namespace. Do not use Quotations. Quotes will indicate to the DoCmd Paramater that you are passing a String Argument. Pass the Object, instead.

    You will need to pass the name of the actual Navigation Control. This is hard to find. The way I remember it, when using the Wizard to create the form, You have the Form Name and then there is the control that is the Navigation thing. This resides just inside the form. This Navigation Control has all sorts of stuff inside of it. Maybe there are some Tabs you need to identify. Your Form Object may be contained within one of those.
    Code:
    [Forms]![mainform]![CorrectNavigationName ].[Form]!tbStart

  7. #7
    Ddempsii is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    24
    Understood. This is painful. I can pull information off the navigation form, as well as switch the navigation form from one form to another. The only thing I can't do is export a simple pdf. This seems like such an easy task.

    Thank you both for your help

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

Similar Threads

  1. Exporting to app, is it possible?
    By shadowsedge in forum Access
    Replies: 1
    Last Post: 04-07-2016, 02:11 PM
  2. Exporting Help
    By manic in forum Access
    Replies: 5
    Last Post: 06-22-2012, 04:46 PM
  3. Exporting to PDF
    By Alaska1 in forum Access
    Replies: 4
    Last Post: 12-16-2010, 09:52 PM
  4. Problem exporting to XML
    By accexp in forum Import/Export Data
    Replies: 2
    Last Post: 09-15-2010, 12:33 PM
  5. Exporting Help
    By mrnikeswsh in forum Import/Export Data
    Replies: 11
    Last Post: 01-16-2010, 11:59 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