Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - Report_HighLightChanges.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: Report_HighLightChanges.mdb
    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.
    (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 
    (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"

Download Access 2K/XP/2K3: uploads/37/


Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.