Results 1 to 4 of 4
  1. #1
    Dalan is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2012
    Posts
    2

    Missing Data when printed to pdf

    I am a beginner using Access 2007. The custom written program that I am using has a minor glitch. The report has a subform inside the main report. In this subform is a form header, detail, form footer. The information that is entered into the main report that transfers to the form header, detail, and form footer works and that data is saved with no problems. When I go to create a pdf file from this report all the data transfers to the printed pdf except the information in the form footer. I have looked at the property pages and compared all the properties and they are all indentical. Below is a screen shot of the report in the design view. The areas circled in red are the data that is missing from the pdf when printed. The area in green prints correctly as well as the main body of the report. We insert comments in the comment section and also type initials in the signature section but this do not show up when printed in the pdf. The database saves the information that is input but does not print it. Not everything in the company has access to the database so this is the reasoning for generating a pdf so that it is placed on the company drive for everyone to see. Thanks in advance for the help.Click image for larger version. 

Name:	Tool Program pic.png 
Views:	11 
Size:	28.2 KB 
ID:	9564

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Put your comments and signature fields in the detail section of yours subform not in the footer.

  3. #3
    Dalan is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2012
    Posts
    2
    Tried this solution. In the detail section of the subreport you can enter multiple data entries. When I moved the comment and signature to the detail portion it started putting the comment and signature between each of the entries.

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Exactly right, if the COMMENTS and SIGNATURE are related to each record in your SUBFORM they should be in the DETAIL section of your SUBFORM.

    If your COMMENTS and SIGNATURE are related to your MAIN CALIBRATION RECORD, they should be data elements on the table driving the MAIN form, NOT the on the table driving the subform.

    What you're saying is that the comments and signature are recorded *1* time for each calibration record, that means they should be on the main form, not the subform and both those fields should appear in your main calibration record.

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

Similar Threads

  1. Replies: 2
    Last Post: 06-20-2012, 02:21 AM
  2. All data missing from a table
    By Geezelweezel in forum Misc
    Replies: 1
    Last Post: 03-01-2012, 12:14 PM
  3. Missing data on form
    By AndycompanyZ in forum Forms
    Replies: 1
    Last Post: 06-24-2011, 03:27 AM
  4. Missing data in report
    By newtoAccess in forum Reports
    Replies: 1
    Last Post: 12-01-2010, 10:40 AM
  5. Replies: 9
    Last Post: 04-27-2010, 01:00 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