order counter

  • Thread starter Thread starter MDSCDK
  • Start date Start date
M

MDSCDK

Is it possible to create a macro that constantly checks for a new record in a
given table, and if it finds a new record, it plays a sound or a beep? For
example, each time the Orders table gets updated with a new record (a new
order), a beep or sound would play? Or a little pop up notification window
would come up on the screen?

Any sample code or advice would be greatly appreciated.

Thanks,
Dan
 
Dan,

No, there is no such thing at a table level.

Can you explain a bit more about what you are doing there. How are the
nw records being added? You can have an event based on the form being
used for data entry - but then what is the point, in that if you are
entering a new record, then you would already know you had added a new
record. If you are talking about a multi-user environment, then you
mean an alert if another user adds a record? In which case, all users
get the alert?
 
Back
Top