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)

Report_HighLightChanges.mdb

 Post Reply Post Reply
Author
Message
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.
 
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"

Download Access 2K/XP/2K3: uploads/37/Report_HighLightChanges.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down