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 - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) 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.
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.

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails


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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Local Continuous Replication is a cost effective and quick way of backing up Exchange server data. The following article describes the steps required to configure Local Continuous Replication. Also, the article tells you how to restore from a backup…
Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now