GoodyGoody
Registered User.
- Local time
- Today, 03:31
- Joined
- Aug 31, 2019
- Messages
- 120
Hi, I am running Access 2013. I am writing a Race Timing database and when it comes to printing the times for a race I have a report which saves all the runtime data to a table so that when summarising the results later for e.g. a series of races (and also for historical purposes) the data is set. I have a process to 'Finalise' the race results which 'prints' the report using the docmd.openreport VBA command and the acHidden parameter. This all seemed to work really well until I noticed that the report when run in acHidden mode onlly updates the first page of times (I also noticed that when it prints to the screen, it only updates the records once it has printed in Preview to the screen so if you only preview page 1, then only the records on page 1 are updated). Is there any way I can force the docmd.openreport command to effectively 'print' every line on the report thus updating all the records or am I going to have to hive off the database update process part of the report to a separate procedure which will be a pain as the report does a bunch of calculations...
As always your thoughts always really welcome.
Thanks
Stephen
As always your thoughts always really welcome.
Thanks
Stephen