向已登录的用户发送消息 [英] Send message to logged on user

问题描述

亲爱的，


这是我在BYTES的第一篇文章。

我是Access VBA的新手。我目前正在做一个数据库，作为2个属性的中央仓库。数据库放在公司网络上，以便来自不同属性的用户可以同时访问。

我已经有了一个代码，用于检查谁使用ADODB登录数据库，工作正常。


这里出现问题，如何向登录用户发送个人消息？像2个用户之间的即时消息。我试图在论坛中查看，我确实发现了一篇2006年发布的帖子并提出了建议。但是现在该帖子中的链接已损坏，无法再打开。


如果有人能给我一些提示，感谢你提前给我一些好处。


Angus L.

Dear all,

This is my first post in BYTES.
I am new to Access VBA. I am currently doing a database which serve as a central warehouse for 2 properties. The database is put on the company network so that users from different properties can access in the same time.
I have already having a code for checking who is logged on the database using ADODB, which works fine.

Here come to the problem, how can I send individual message to the logged on users? Something like an instant message between 2 users. I tried to look in the forum and I did found a post which posted in 2006 and have a suggestion. But now the link in that post was damaged and could not open any more.

Much appriciated if anyone could give me some hints, thanks for your kindness in advance.

Angus L.

推荐答案

如果您将链接发布到旧线程，您会发现我是否可以修复该链接。否则，从我们看不到的线程开始工作非常困难。

If you post the link to the old thread you found I''ll see if I can fix the link. Otherwise, it''s very hard to work from a thread we cannot see.

在那之前，我会说Access不适合这样的IM系统。我能想到的最好的方法就是有一张表格里面有这样的信息。您需要实现一个接口 - 使用表单 - 允许您将此类消息发布给用户。您还需要一个系统，登录用户可以在出现时显示消息。为此，我会考虑一个由定时器驱动的轮询机制，它定期检查表的内容。当发现一个与当前登录用户相关时，它将以表格形式显示。


欢迎来到字节！

Until then, I would say that Access is not well suited to such an IM system. The best I can think of would be to have a table which held such messages. You would need to implement an interface - using a form - that allowed you to post such a message to a user. You would also need a system whereby a logged on user could have the message show whenever one appeared. For this I would consider a polling mechanism, driven by the timer, which periodically checked the contents of the table. When one was found relevant to the currently logged on user it would be displayed in a form.

Welcome to Bytes!

@angusfreefa


NeoPa在这个问题上几乎触手可及，我会尽力协助。


有一种机制可以在不使用电子邮件的情况下向多用户环境中的其他用户发送伪即时消息。该系统涉及Table，Form，Timer（）事件，以及共享数据库中表的使用，所有用户都可以访问该表。该表促进并包含与消息传输有关的数据。当我有机会时，我会简单地将系统作为附件发送给您并附上说明。

@angusfreefa
NeoPa pretty much hit the nail on the head with this one, I''ll just try to assist.

There is a mechanism by which you can Send ''Pseudo'' Instant Messages to other Users in a Multi-User environment without using E-Mail. This system involves a Table, Form, Timer() Event, and the use of a Table in a Shared Database to which all Users have access. This Table facilitates and contains data relating to the transference of Messages. When I get a chance, I''ll simply the system and send it to you as an Attachment with instructions.

这篇关于向已登录的用户发送消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！