Question Chat Option

[asif pasha]

Hi All,

I am thinking to build an application in access where in we can chat with each other, without any internet connection, the access file will be saved in the shared drive. Something like we retrive username using ReturnuserName function, and send the pop up to the respective user. I know this will be a very lenghty and quite stressfull, but we can try.

Any comments would be appreciated.

Thanks in advance.

 

[JamesMcS]

Not really complicated, but why? There are a ton of free IM clients out there...

All you'd need to do is have the message sent appended to a table with the receipient ID, then have a form with a timer event going to check the table where the recipient ID=current user id.

 

[asif pasha]

Hi James :Thanks for your quick reply.
The reason i want to built this is because we are not suppose to use any IM clients. I have created a db where in it will capture the data of the process, in the same db i wanted to introduce this chat option, where in they can communicate each other instantly. For example they can ask any query, calling for breaks, so this will actually saves time for each and every individual rather than going to their seat.
If you have any sample please post so that i can refer and start creating with my own logic. For your information we use A 97.

Thanks.

 

[JamesMcS]

Not sure there will be any samples about, not something access was really designed for - just go with the steps above:

1. User writes their message and clicks 'send'
2. Sender Id, Recipient ID and message are appended to a table
3. Recipient has a database running with a form based on a query that picks up messages where the recipient ID matches their ID.

Or, they can just pick up the phone or send an email, or walk over to the recipient's desk

 

[smig]

if you are not suppose to use any IM clients, why are you trying to build one ?

 

[JamesMcS]

Good point, I hesitated to ask.... if you're going to build one, you might as well just download one... and get your boss to spend some money and upgrade your version of Access