Notify of New Customer

T

Tom Lewis

I have a "waiting list" Access database at work used for customers to log
into. The clerks who wait on the customers are logged into a linked database
with a form that shows them the customers are waiting, why they are here and
who they are here to see. The clerk acknowledges the customer with their
name and the record is permanently written to a customer table. I have a
requirement to create a notfication of some sort on the linked database that
a new customer has logged in (right now the database is open all of the time
but has to be maximized frequently to see the list of customers). I'm
thinking of a flash of 'CUSTOMER' at the bottom of the screen when one exists
or at last resort, a continuous beep while a customers name exists. Any
ideas how to code? Thanks.
 
Top