Highlight new data added to Access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Updated New data imported into Access table needs to be a diffrent color to
draw attention to it.
 
Where do you want it to be a different color? On a form? What kind of form?
How do you know which records are new?
 
Thanks Klatuu; I get the data from an outside database, import this data
into Access. Make a Table query with data broken down by months. Each
record has a unique id number (indexed). Since the data from the outside
database gets updated frequently, I run this process and need to highlight
only the new data, preferably in a data sheet lay out so I can print it. I
have made forms so my boss can review what is going on, but the form goes
record by record. It would be beneficial if the new data was highlighted
here too.
 
Okay, it can be done, but will take a little thinking and planning. The
first issue is know when a record is considered new and when it is considered
no longer new.

One way to identify new records would be during the import. Add a Yes/No
field to the table and call it something clever like NEW_REC. (sometimes my
brilliance amazes even me). I assume you are using an append query to add
the new records to the table. In that query set the value of NEW_REC to true.

For your form, add an invisible control bound to NEW_REC. Then for each
field you want to highligt for the new records, use conditional formatting to
make the appearance whatever you want if NEW_REC = True. You can do the same
for the printed report.

At some point, they will be no longer new. I would suggest an update query
that will chage NEW_REC from True to False. Where you execute this query
will depend on your business rules.
 
Thanks again; In the Words of Bruce Campbel, Nikktuu, Klatuu, Neferammmm.
Your a God! It works great.
 
Bruce Campbell, one of my heros, was quoting from an old SciFi movie "The Day
the Earth Stood Still". It was a message being delivered from Klaatu to
Gort by Helen Benson. There is debate over what the message actually meant.
Some think it meant "Come get me, I need help". Others say it meant "Don't
destroy Earth, yet."
 
Back
Top