Access 2003 Sending screen pop to another user.

Posted on 2008-10-20
Last Modified: 2013-11-10
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.
Question by:jdfuller
  • 4
  • 3
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 250 total points
ID: 22763707
You could do this:

In the remote mdb(s), you have a small table that contains a flag you set remotely along with the message, maybe a date time field if necessary.

From the mdb you want to send from, you can use the OpenDatabase method to populate the remote table's flag.

Then, in the Remote mdb(s), you will need a timer running in any relevant form(s) that periodically checks the table for the flag.  And some code to reset to clear the flag once the message is read.

LVL 75
ID: 22763714
"that periodically checks the table for the flag."

and then pops up a message to that effect.


Author Comment

ID: 22764017
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.
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

LVL 75
ID: 22764449
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.


Author Comment

ID: 22764799
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.
LVL 38

Assisted Solution

by:Jim P.
Jim P. earned 250 total points
ID: 22845261
Is there a way to turn this app into SQL Express back end?

Then you could take advantage of triggers and such to automate the process.

The ee-stuff expert notif came out several months before the Neglected Q notifs finally hit. In fact I think that was the incentive for the neglected.

Author Comment

ID: 22858104
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..


Accepted Solution

jdfuller earned 0 total points
ID: 22864852
I disagree. No solution is not a solution. The solution requested was not available in this dialog. It doesn't mean it doesn't exist.

I do agree that it may be useful for others searching for similar solutions.

Moderator may award points as is fitting by his judgement. I would agree to a split.

Thank you for your input.

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question