pop up box message

[fishqqq]

I'm looking for a way to have a user update some data on a form and
when they close that form some of the data gets sent to their manager
in the form of a pop up screen that interrupts what the manager is
currently working on.

the user and the manager would both be on access at the same time. it
would be nice if there was a problem the user could update a screen
and the data would be sent immediately to the manager - interrupting
what ever access screen (form) they are currently in.

is this possible?

Tks

 

[Stuart McCall]

I'm looking for a way to have a user update some data on a form and
when they close that form some of the data gets sent to their manager
in the form of a pop up screen that interrupts what the manager is
currently working on.

the user and the manager would both be on access at the same time. it
would be nice if there was a problem the user could update a screen
and the data would be sent immediately to the manager - interrupting
what ever access screen (form) they are currently in.

is this possible?

Tks

Well here's one way:

http://www.smccall.demon.co.uk/MiscApi.htm#Netsend

 

[fishqqq]

Well here's one way:

http://www.smccall.demon.co.uk/MiscApi.htm#Netsend

thanks but this is too complicated for me... i was hoping for
something a little easier to get through.

 

[Access Developer]

If they are on the same network, using the same backend database, you can
communicate via the back end, and have code in the manager's copy of the app
that is executed on a timer and checks to see if a particular value has been
set in the backend tables. It will not be "instantaneous" but you can set
the timer value to whatever you want... the more frequently it fires and
executes the code, the more overhead you will add to the manager's
application.

In the manager's application, you can issue a MsgBox, which should get the
manager's attention, even if he's using a different application (in most
versions of Access and Windows, at least).

I think you're looking at writing some VBA code, but perhaps you could do it
with macros: one when the user closes that particular form, or moves to
another record; another in the timer code to check for the value, and to
issue a MsgBox and reset the value if it has been set.