About trigger

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hanski - 15 Jul 2007 07:38 GMT

Hi.

My application works on Accessa 2000. Alla my data are in SQL server,
so there is an ODBC link between them.

I have a table which includes for instance names of countries.

Is it possible to creater some kind of trigger or something else to
automatically popup a message box to each user, when someone adds a
new coutnry to the database? User would not have to go and see,
whether there are new countries in database, but the application tells
the user when new countries are added.

thanks

Hannu

Reply to this Message

scubadiver - 16 Jul 2007 12:30 GMT

I have a suggestion that may work.

With the country name you would need a checkbox (default value set to
"true") and a date field (default value set to "=Date()"). So when you enter
a new country you know the date in which it was entered.

Create an update query so that if the difference between the entered date
and today's date is greater than a certain amount then change the checkbox
from "true" to "false" (I think this will depend on how often the database is
used). This query would have to be fired when the database is closed (with a
command button)

When the database is opened you want some method to check if there is at
least one checkbox set to "true". If there is then you fire the popup. Though
I wouldn't be too sure how to do this.

> Hi.
>
[quoted text clipped - 12 lines]
>
> Hannu

Reply to this Message