Automatic Notification

[Guest]

I have a Dreamweaver application that has successfully written to a spl table
in Access. I just need to have Access know when a new record has been
written to the spl table so I can have it kick off a series of macros. I can
(I think) figure out all the macros but how to get things started when a new
record comes in is driving me nuts. Ideas?

Thanks for your assistance!

 

[Guest]

Unfortunately Access does not have table-level triggers like some other
database. If it did, this would be easy.

You could use the Timer event of a form to do a DCount of the number of
records in the table in question and compare that value against something
stored in another table. If it is greater, run the macros. Also if it is
greater, update the table holding the value.

Another idea would be to add a field to the spl table called NewRecord. Make
it a Yes/No field with the default being Yes. On the On Timer event of a form
(which must be open but can be hidden) check every few minutes for new
records. If it finds one, runs the macros then updates all the records in the
NewRecord field to No.

 

[Guest]

Thank you for the information and the options. Super Ideas! Thanks

 

[Jaime Mediavilla]

si