Highlight new data added to Access database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Duck - 28 Mar 2006 22:21 GMT

Updated New data imported into Access table needs to be a diffrent color to
draw attention to it.

Reply to this Message

Klatuu - 28 Mar 2006 23:30 GMT

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?

> Updated New data imported into Access table needs to be a diffrent color to
> draw attention to it.

Reply to this Message

Duck - 29 Mar 2006 14:35 GMT

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.

> 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?
>
> > Updated New data imported into Access table needs to be a diffrent color to
> > draw attention to it.

Reply to this Message