jdfuller
asked on
Access 2003 Sending screen pop to another user.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have a timed refresh on the journal action item form already. It does just that. What I was hoping for was something like an instant message that pops right on the screen as the other user is closing the item they have finished. I suppose it would be instant if the refresh timer went off right after the user set the flag but to check the status of the flag so frequently would compromise the performance of the database. I was hoping for somehting more event driven.
This product has a feature that does this, but ... it's based on the same principle. The difference is, you can send the message from their interface. I this product - won it in a drawing. However, if FMS couldn't figure out a better way, then it's not likely one exists.
http://www.fmsinc.com/MicrosoftAccess/monitor.asp
mx
http://www.fmsinc.com/MicrosoftAccess/monitor.asp
mx
ASKER
Yes. I've seen this program. I know the FMS folks and you're probably right that they would have a way if there was one. Thanks for the input, mx, but I'm in need of the event driven solution. An email message is probably my best hope but I didn't want to be tied to a 3rd party app. or anything external to the application.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It will be ported to SQL in the coming months. Maybe we will have to wait for that event before the feature is deployed.
Thanks all..
JDF
Thanks all..
JDF
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"that periodically checks the table for the flag."
and then pops up a message to that effect.
mx