Send message(box) to user

[kermit01de]

Hi all,

is there any "built-in-solution" for the following scenario?

- Form - field "Finished" is set to true
- Messagebox is sent to accessuser "ITDS"

I found an external solution, but am still wondering if there is any internal possibility.

--------------------------------------
>>>>>> Bugs will appear in one part of a working program when another 'unrelated' part is modified <<<<<

 

[PHV]

if there is any internal possibility
To do WHAT and WHEN ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kermit01de]

As described above:

WHAT: Send Messagebox to accessuser "ITDS"

WHEN: field "Finished" is set to true on form


--------------------------------------
>>>>>> Bugs will appear in one part of a working program when another 'unrelated' part is modified <<<<<

 

[randy700]

How about SendObject?

Randy

 

[kermit01de]

Alle I found about SendObject is that it is able to send email. Or is there a trick to pop up a message without Lotus Notes?

--------------------------------------
>>>>>> Bugs will appear in one part of a working program when another 'unrelated' part is modified <<<<<

 

[boblarson]

You can't send a message as such but you could do something that would pop up when they were in Access.

What you would need to do is to have a linked table where you can put a message and the user's login id. You could use a form to do that. That would be input on your end.

The table would need to be in the backend database so that the frontends could all be linked on it.

Then you have a hidden form that loads and has a timer on it. It could run a check in that table for any messages for that particular user (you can use Environ("username") or better yet, the Windows API to get their network login for the form to check against that table.

If it finds a message there you could open either a message box or a form of your own design (I would choose the latter option because you could use the OK button of that form to then add a VIEWED status to the table with the message so that the timer wouldn't bring it up again. You would need to bring up your form as a dialog so it pauses execution of the hidden form's timer event, giving your user time enough to click on OK and then the field is updated and then the same message would not be displayed again.

I hope that helps.

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com