Hi All,
We have an Access front end with SQL Server backend.
What I want to achieve is when a user in the pharmacy performs an action to say treatment is ready (table updated) the form that appears on the ward (and run on a separate PC) gets refreshed to inform them that treatment is ready.
I did consider using the time interval function but past experience tells me this slows down the system and would prefer a different approach.
I can leave it so users have to manually press the refresh button but that's just going to irritate all.
Any ideas welcome.
We have an Access front end with SQL Server backend.
What I want to achieve is when a user in the pharmacy performs an action to say treatment is ready (table updated) the form that appears on the ward (and run on a separate PC) gets refreshed to inform them that treatment is ready.
I did consider using the time interval function but past experience tells me this slows down the system and would prefer a different approach.
I can leave it so users have to manually press the refresh button but that's just going to irritate all.
Any ideas welcome.