A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Missing Data When Printing from new record



 
 
Thread Tools Display Modes
  #1  
Old September 2nd, 2009, 11:05 PM posted to microsoft.public.access.reports
Jay Myhre
external usenet poster
 
Posts: 6
Default 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  
Old September 3rd, 2009, 12:44 AM posted to microsoft.public.access.reports
Jay Myhre
external usenet poster
 
Posts: 6
Default 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  
Old September 3rd, 2009, 12:55 AM posted to microsoft.public.access.reports
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.