Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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
  • 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.
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

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 Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Implementing simple internal controls in the Microsoft Access application.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Loops Section Overview
Suggested Courses

564 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