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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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.
Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

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

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This article will help to fix the below errors for MS Exchange Server 2013 I. Certificate error "name on the security certificate is invalid or does not match the name of the site" II. Out of Office not working III. Make Internal URLs and Externa…
how to add IIS SMTP to handle application/Scanner relays into office 365.

729 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