Access 2003 Sending screen pop to another user.

Posted on 2008-10-20
Medium Priority
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 1000 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.
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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 1000 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 Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

765 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