Results 1 to 7 of 7
  1. #1
    Erichss is offline Novice
    Windows 10 Office 365
    Join Date
    Jun 2022
    Posts
    4

    Saving Form

    I have a form that is used to enter in data.
    The filled out form get saved as a PDF when the record gets saved, but the issue it the form has an website embedded in it (which needs to be there).
    The form gets saved as a totally blank PDF, but if I to remove the embedded site it saves as it should.



    How can I get the form to save correctly with the embedded site on it still?

    The code to save the form is:
    DoCmd.OutputTo acOutputForm, "FORM1", acFormatPDF, "Location"

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,526
    you should really save a report, instead of the form.

  3. #3
    Erichss is offline Novice
    Windows 10 Office 365
    Join Date
    Jun 2022
    Posts
    4
    When I tried it that way, it pulling the entire table and not just the single record.

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,948
    Quote Originally Posted by Erichss View Post
    When I tried it that way, it pulling the entire table and not just the single record.
    Does no one do any research anymore?

    Why not look at the syntax of the OpenReport command?

    https://learn.microsoft.com/en-us/of...cmd.openreport

    Then a simple Google search.
    https://www.google.com/search?q=docm...hrome&ie=UTF-8
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    Erichss is offline Novice
    Windows 10 Office 365
    Join Date
    Jun 2022
    Posts
    4
    Does no one answer a question for somebody who has VERY LITTLE Access experience without sarcasm anymore.

  6. #6
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,474
    You can create a report to minic the form(copy the fields over if needed) and for the RecordSource of the report, make it a query where you only show that one record. But not sure of why it is showing blank. Maybe try making the Webpage a sub report on the main report and see if that works.

  7. #7
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,948
    Quote Originally Posted by Erichss View Post
    Does no one answer a question for somebody who has VERY LITTLE Access experience without sarcasm anymore.
    Not sarcasm, genuine dissapointment.
    I gave you the links. perhaps have the courtesy of looking at them? They will solve this particular problem if you take the trouble to do so.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Saving a form
    By Kelev Gadol in forum Access
    Replies: 11
    Last Post: 03-25-2023, 03:22 PM
  2. Saving a Form
    By brentb in forum Forms
    Replies: 2
    Last Post: 01-27-2020, 09:12 PM
  3. Replies: 3
    Last Post: 04-22-2015, 04:35 AM
  4. Sub-Sub-Form Saving
    By QuantifyRisk in forum Forms
    Replies: 17
    Last Post: 09-19-2014, 12:36 PM
  5. Replies: 10
    Last Post: 10-22-2013, 07:35 AM

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