user messaging

[sdel_nevo]

Hi All

i have been asked by the powers at be if i can add a messaging system into our existing access database application.

each user logs into the system with there own username and password, and each has a access level such as "admin" "power user" and "user", once logged in they are directed to a form called dashboard, what i have been asked to do is to have the ability to send messages to users or groups of users, and for there to be a notification appear in the top right hand side of the dashboard form if there are any new messages for them.

they can then reply to these if required (or better still turn around and talk to each other as everyone here sits at most 6 feet apart lol)

the messaging i think i can do, but i'm not sure how i could do the notification part, i was thinking that i could somehow check for new messages in a message table every x amount of time, could this be done with the on timer event?

steve

[pbaldy]

The timer event is what I would use, yes.

[sdel_nevo]

Hi Paul

great, im on the right track what i can't seam to get my head around is how i would code it to check for new messages.

do you have any ideas? or now of any pointers

Steve

[pbaldy]

Offhand I'd probably have a yes/no field in the messages table to signify that a message has been read, so my new message check would be looking for messages for the logged in user where that field was False (or however you decide to set it).

[sdel_nevo]

Hi Paul

great, will go that way

Cheers

Steve

[pbaldy]

Sounds interesting, good luck! Post back if you get stuck.

[sdel_nevo]

Hi Paul

will do

i have been really thrown into the deep end with this, the last developer walked out (oh joy) and i have taken over the mantle so to speak.

anyway many thanks

i will let you know how i get on if thats ok

Steve