By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,281 Members | 2,201 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,281 IT Pros & Developers. It's quick & easy.

send command to other users within access

P: n/a
Hello,

I'd like to send command or message within access to other users who are
connected to the same mdb file.

Is that possible ?

thanks in advance.

Nader
Jun 15 '06 #1
Share this Question
Share on Google+
10 Replies


P: n/a
"Nader" <na***@infomaniak.ch> wrote in message
news:44*********************@news.sunrise.ch...
Hello,

I'd like to send command or message within access to other users who are
connected to the same mdb file.

Is that possible ?

thanks in advance.

Nader

Yes, use a form in conjunction with the form's timer event. Use it to check
a flag in a table. If the flag is set, open a dialog form with your custom
message which could, for example, be stored in the same table as the flag.

HTH - Keith.
www.keithwilby.com
Jun 15 '06 #2

P: n/a
isn't that timer going take more of my cpu perfomance or at least more
memory usage ?

"Keith Wilby" <he**@there.com> a écrit dans le message de news:
44**********@glkas0286.greenlnk.net...
"Nader" <na***@infomaniak.ch> wrote in message
news:44*********************@news.sunrise.ch...
Hello,

I'd like to send command or message within access to other users who are
connected to the same mdb file.

Is that possible ?

thanks in advance.

Nader

Yes, use a form in conjunction with the form's timer event. Use it to
check a flag in a table. If the flag is set, open a dialog form with your
custom message which could, for example, be stored in the same table as
the flag.

HTH - Keith.
www.keithwilby.com

Jun 15 '06 #3

P: n/a
but what do u mean by check a flag in a table ? is this an option when u
create a table ?
"Keith Wilby" <he**@there.com> a écrit dans le message de news:
44**********@glkas0286.greenlnk.net...
"Nader" <na***@infomaniak.ch> wrote in message
news:44*********************@news.sunrise.ch...
Hello,

I'd like to send command or message within access to other users who are
connected to the same mdb file.

Is that possible ?

thanks in advance.

Nader

Yes, use a form in conjunction with the form's timer event. Use it to
check a flag in a table. If the flag is set, open a dialog form with your
custom message which could, for example, be stored in the same table as
the flag.

HTH - Keith.
www.keithwilby.com

Jun 15 '06 #4

P: n/a
"Nader" <na***@infomaniak.ch> wrote in message
news:44*********************@news.sunrise.ch...
but what do u mean by check a flag in a table ? is this an option when u
create a table ?


Using the timer event will be no noticable overhead on your PC if you set an
interval of, say, 15 seconds. I'm suggesting a table with two fields,
"Flag" (Yes/No) and "Message" (text). Your main form's timer event would
poll the "Flag" field every 15 seconds and do nothing if it returns false.
If it returns true then a second (dialog) form would open and display the
message in the "Message" field.

HTH - Keith.
www.keithwilby.com
Jun 15 '06 #5

P: n/a
If you want it to be unique to user, you would have to add userid or
logon id to the table.

Also will have to have some type of delete logic involved, in all
cases. so that after the user has read it then the message is deleted.
(or add a read flag and have the reading process set that flag)
Otherwise the same message will keep coming up over and over.

If it is for all users (not just one) you will have to think about
knowing who has seen it and who has not and how to keep it from coming
up over and over and over and over.
www.keithwilby.com


Jun 15 '06 #6

P: n/a
"Ron2006" <ro******@hotmail.com> wrote in message
news:11**********************@h76g2000cwa.googlegr oups.com...
If you want it to be unique to user, you would have to add userid or
logon id to the table.

Also will have to have some type of delete logic involved, in all
cases. so that after the user has read it then the message is deleted.
(or add a read flag and have the reading process set that flag)
Otherwise the same message will keep coming up over and over.

If it is for all users (not just one) you will have to think about
knowing who has seen it and who has not and how to keep it from coming
up over and over and over and over.


All valid points and it makes me wonder why the OP would want to do this.
Is it so as to be able to ask users to log out when BE maintenance is
required? If so then there are more elegant ways to achieve this than to
send them a message and rely on them actually being there and complying with
your request.

Regards,
Keith.
Jun 15 '06 #7

P: n/a
My 2 cents.
I have been doing this for several years in our database. We
use it kind of like an instant messaging system. "Hey did you get me
that Part Number" Yes, its 1234" I set it up like an email system.

As the other posters suggested, its just a table. I have the
Senders ID the Receipient(s) IDs, the subject, the message, the Time
sent, and whether is was read or not. Each user sets up a time to be
reminded of messages from One Minute to One Hour and on his front end
only, I look for messages at that periodic rate. As suggested before,
there seems to be little overhead penalty.

It's a convenient, if unsophisticated tool. One good thing is
we have a permanent record of the entire diatribe.

It you need more help, let me know.

Hank Reed

Jun 15 '06 #8

P: n/a
Thanks to all of you.

I'll try this solutions right away.

"Hank" <ha********@aol.com> a écrit dans le message de news:
11**********************@g10g2000cwb.googlegroups. com...
My 2 cents.
I have been doing this for several years in our database. We
use it kind of like an instant messaging system. "Hey did you get me
that Part Number" Yes, its 1234" I set it up like an email system.

As the other posters suggested, its just a table. I have the
Senders ID the Receipient(s) IDs, the subject, the message, the Time
sent, and whether is was read or not. Each user sets up a time to be
reminded of messages from One Minute to One Hour and on his front end
only, I look for messages at that periodic rate. As suggested before,
there seems to be little overhead penalty.

It's a convenient, if unsophisticated tool. One good thing is
we have a permanent record of the entire diatribe.

It you need more help, let me know.

Hank Reed

Jun 15 '06 #9

P: n/a
I'd love to know about the other ways you have in mind. I use a table
similar to the one described and would love to know another way to go at it.
Jun 16 '06 #10

P: n/a
<w_a_n_n_a_l_l_ -@-_s_b_c_g_l_o_b_a_l._n_e_t> wrote in message
news:B1*******************@newssvr27.news.prodigy. net...
I'd love to know about the other ways you have in mind. I use a table
similar to the one described and would love to know another way to go at
it.


Why bother asking the user to log out when you can force them off without
their intervention? You'd still use a table but that table would contain
either a time to log off, a specific user to log off or a specific computer
name to log off. It's a system I use and it works without fail.

Keith.
Jun 16 '06 #11

This discussion thread is closed

Replies have been disabled for this discussion.