Listen to a table

[Guest]

Hi All,
I'm having a table that gets data rows from an external application, and I
need to manipulate or insert similar rows according to specific field data.
Is it possible to "listen" to a table and run a subrutine each time a new
record was instered or updated?
Thanks a lot in advance

 

[Alex Dybenko]

Hi,
if you are talking about Access table - then there in to event you can
listen when record added. But you can read number of records in a table
every minute or hour to find that new record(s) inserted

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Guest]

Thanks Alex,
I think that's the idea. Can you send/post me to a source example?
Thanks again

 

[pietlinden]

Thanks Alex,
I think that's the idea. Can you send/post me to a source example?
Thanks again

create a form with a timer, OnTimer, check the record count in the
table. Write it to a form-level variable in the form.
If DCount() > lngRecordCount Then
'... new records added
End If