Print Page | Close Window

Report_HighLightChanges.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=54
Printed Date: 24 Oct 2017 at 7:30am


Topic: Report_HighLightChanges.mdb
Posted By: A.D. Tejpal
Subject: Report_HighLightChanges.mdb
Date 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: http://www.rogersaccesslibrary.com/forum/uploads/37/Report_HighLightChanges.zip -




Print Page | Close Window