date in database compare with the current date

G

gpl666666

Is that possible to create an alert function, that gives an alert
message when a date in Access database is going to expired soon
So I need this function to compare the date in database with current
date
when the dates are the same, it gives an warning msg on the web
browser

and is that possible to achieve that using Microsoft script editor?
 
M

Michel Walsh

Hi,

Sure, but you need to write code. The basic idea would be to check when the
next event should occur, and run Schedule Tasks, or other tool,
appropriately. Sure, you have to check that when the db is loaded, when a
record is appended, modified, or deleted, and also, there, interact with the
tool you use. It would thus a little bit easier doing all this using MS SQL
Server T_SQL to program the triggers (which do no exist, per se, in Jet).

It is NOT something 'right out of the box', though. You have some 'serious'
development to do (and, mostly, testing, to see if you handle well all the
possible cases that may occur). As example, what if the next event to occur
is rescheduled.

Another alternative, assuming Access is always running in the background, is
to use a form timer and, in the timer event handling procedure, make the
appropriate checks. That procedure requires less development, probably, but
may be heavier on the resources (and execution time spend by each firing of
the timer event).


Hoping it may help,
Vanderghast, Access MVP.
 
M

Michel Walsh

Sorry, just read you other post. (I am out of sequence, :-( )

I am not sure that the solution I proposed is well adapted to your case... I
though you were using a Jet-VBA scenario, when I answered.


Vanderghast, Access MVP
 
Top