How to check updated information?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hanski - 16 Jul 2007 09:13 GMT

How can I automatically check if there has data changed in a table?
Can I have a popup about that?

Hannu

Reply to this Message

Lynn Trapp - 16 Jul 2007 14:07 GMT

Could you describe more about what you mean by data changing and WHEN
you want to automatically check this? You can always create an audit
trail that is triggered on the after update event of your data entry
form and use that to see what has changed. Can you give us more to go
on?

Lynn Trapp
MS Access MVP

>How can I automatically check if there has data changed in a table?
>Can I have a popup about that?
>
>Hannu

Reply to this Message

hanski - 17 Jul 2007 06:49 GMT

On 16 hein?, 16:07, Lynn Trapp <noltr...@spamltcomputerdesigns.com>
wrote:

> Could you describe more about what you mean by data changing and WHEN
> you want to automatically check this? You can always create an audit
[quoted text clipped - 14 lines]
>
> - N?yt? siteerattu teksti -

Hi.

I mean that for instance someone adds a new field into table and other
users would get the information about that.

So if I add a new name, Peter, into a table, other users would get
somehow the information that there is a new field in a table without
doing anything. So the information would become automatically to other
users knowledge.

Hannu

Reply to this Message