If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Missing Data When Printing from new record
I am using MS Access 2003. I am creating a database that records and
prints patient care data. The form has 15 sub-forms which are needed to collect data that can have multiple selections. On the form I have a button that when clicked on will save the data then print a patient care report (which also has many sub-reports). The problem is that when entering and printing a new record, not all the data prints. When I exit the data entry form then go back to that record and print, all the data prints. Is there some code I can insert either in the data entry form or the printed report that forces the report to wait until all the data has been "loaded" before it prints. Or, is there another problem I'm not thinking of? P.s. This is basically the same application I previously wrote in Access 2000 and did not encounter this problem in that database. |
#3
|
|||
|
|||
Missing Data When Printing from new record
Steve - I failed to mention that I already have the application execute that
line of code in prior to the print function. Thanks for the reply. "Steve" wrote: It sounds like some of the data you just entered on the data entry form has not yet been saved when you click the button to print the report. Put te following code at the beginning of your code in the Click event of the button: DoCmd.RunCommand acSave Steve "Jay Myhre" wrote in message ... I am using MS Access 2003. I am creating a database that records and prints patient care data. The form has 15 sub-forms which are needed to collect data that can have multiple selections. On the form I have a button that when clicked on will save the data then print a patient care report (which also has many sub-reports). The problem is that when entering and printing a new record, not all the data prints. When I exit the data entry form then go back to that record and print, all the data prints. Is there some code I can insert either in the data entry form or the printed report that forces the report to wait until all the data has been "loaded" before it prints. Or, is there another problem I'm not thinking of? P.s. This is basically the same application I previously wrote in Access 2000 and did not encounter this problem in that database. |
#4
|
|||
|
|||
Missing Data When Printing from new record
Jay,
Please copy paste the code you are using here. And also confirm, do you have 15 subreports? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Jay Myhre" wrote in message ... I am using MS Access 2003. I am creating a database that records and prints patient care data. The form has 15 sub-forms which are needed to collect data that can have multiple selections. On the form I have a button that when clicked on will save the data then print a patient care report (which also has many sub-reports). The problem is that when entering and printing a new record, not all the data prints. When I exit the data entry form then go back to that record and print, all the data prints. Is there some code I can insert either in the data entry form or the printed report that forces the report to wait until all the data has been "loaded" before it prints. Or, is there another problem I'm not thinking of? P.s. This is basically the same application I previously wrote in Access 2000 and did not encounter this problem in that database. |
Thread Tools | |
Display Modes | |
|
|