Pushing forms

[Guest]

Good morning
I would like to set up a messaging in Access that would open a form on my machine (assuming I'm in the same database) when another user in the same database clicks on the 'online help' button. The form on my machine would contain the other user's userID (through an NT userID api) and a request for help. Once I click OKAY, I'd like another form with the to: (other ID automatically entered in) and Message: textboxes for me to respond. I'd like logging (I can do that easily enough...), but I would like each user's form to be updated at each instance of the SEND button being pressed, including the previous response/comment

Has anyone done this before? My company doesn't permit IMs, so it would have to be within MS Access. We're on Win2000 machines with Access 2000 as the db application. No runtimes since we don't have Developer Editions

Thanks
Derek

 

[Michel Walsh]

Hi,


One of the easiest way would be to have a timer that check, at each
minute, if there is an unread message for you, in a table, and to display it
if there is one. The sender would just have to append a new record in the
table, specifying your name ( as recipient ). Since the messages are put in
a table, even if the recipient is not "on line", the message won't be lost.
The table acts like a mail box.


Another possibility is to use a TCP-IP socket, its main advantage is
that is it faster (no pooling required), but require more code. There is no
"mail box" behavior. Yet another possibility, if you plan to have more than
two users, is to consider Direct Play messaging (Direct Play is a component
of DirectX, you need a DirectX 8 reference, since DirectX 9 does not support
VBA), its main advantage being that it handles the matrix of
inter-communication for you.



Hoping it may help,
Vanderghast, Access MVP

Good morning,
I would like to set up a messaging in Access that would open a form on my

machine (assuming I'm in the same database) when another user in the same
database clicks on the 'online help' button. The form on my machine would
contain the other user's userID (through an NT userID api) and a request for
help. Once I click OKAY, I'd like another form with the to: (other ID
automatically entered in) and Message: textboxes for me to respond. I'd
like logging (I can do that easily enough...), but I would like each user's
form to be updated at each instance of the SEND button being pressed,
including the previous response/comment.

Has anyone done this before? My company doesn't permit IMs, so it would

have to be within MS Access. We're on Win2000 machines with Access 2000 as
the db application. No runtimes since we don't have Developer Editions.

 

[Guest]

Good morning. I had thought of the OnTimer event trigger. I'm barely able to spell VBA let alone DirectX. Although it seems something worth looking into. I think that my hidden copyright form can run the OnTimer for each user, and if a new message comes in within the last say, 3 minutes or something, it can open up the messenger form

I am having trouble with the refresh of the subform, but I'm still working on that. Once a record is added to the table/query behind the subform (which isn't linked to the mainform), all I get is #Name?'s all over the place on the subform

Thanks
Dere

----- Michel Walsh wrote: ----

Hi


One of the easiest way would be to have a timer that check, at eac
minute, if there is an unread message for you, in a table, and to display i
if there is one. The sender would just have to append a new record in th
table, specifying your name ( as recipient ). Since the messages are put i
a table, even if the recipient is not "on line", the message won't be lost
The table acts like a mail box


Another possibility is to use a TCP-IP socket, its main advantage i
that is it faster (no pooling required), but require more code. There is n
"mail box" behavior. Yet another possibility, if you plan to have more tha
two users, is to consider Direct Play messaging (Direct Play is a componen
of DirectX, you need a DirectX 8 reference, since DirectX 9 does not suppor
VBA), its main advantage being that it handles the matrix o
inter-communication for you



Hoping it may help
Vanderghast, Access MV

Good morning
I would like to set up a messaging in Access that would open a form on m

machine (assuming I'm in the same database) when another user in the sam
database clicks on the 'online help' button. The form on my machine woul
contain the other user's userID (through an NT userID api) and a request fo
help. Once I click OKAY, I'd like another form with the to: (other I
automatically entered in) and Message: textboxes for me to respond. I'
like logging (I can do that easily enough...), but I would like each user'
form to be updated at each instance of the SEND button being pressed
including the previous response/commenthave to be within MS Access. We're on Win2000 machines with Access 2000 a
the db application. No runtimes since we don't have Developer Editions