Access 2003 Sending screen pop to another user.
Posted on 2008-10-20
Small environment. SBS 2003 w SP2, Exchange. Running Access 2003 Custom App from clients who login with username and password (different from domain credentials - some). Would like to have an event that sends message to another user on the system who has the database open; for example, a screen would pop up on the named users machine saying "You have a message." or something to that effect. Any ideas? I can send an email but don't want to rely on the local email client for sending. I detect a field (Y/N) for reply requested on a journal entry that requires action. When the "assigned" user has completed the action (fills in the completed date) I want the event to notify the creator of the journal entry that the task was completed by popping a form on the orginating user's machine. The user may then click a button on the form that opens the item of interest.