Report_HighLightChanges.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 07 Jul 2008 at 10:55pm |
This sample db examines the values on report with current data, as compared to the one with old data, and highlights any changes in bold red. If current data contains any fresh records, over and above the old data, these get highlighted in light blue back color. The objective is achieved through generic code in report's module, without needing any specific conditional formatting of individual controls. Important: (a) The report must have a bound control named TxtPk, representing the primary key uniquely identifying a record. This control can be kept hidden if so desired. (b) Name of query representing old data must be the same as that of query serving as record source for current report, but with a suffix "_OLD". For example, if the record source for current report is named, "Q_A", the query representing old data will be named "Q_A_OLD"
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |