send a message for user (1 Viewer)

smahdih

New member
Local time
Today, 16:27
Joined
Nov 16, 2011
Messages
7
suppose that we have 2 pc, and 2 user named Aria and shahin
a database share between 2 pc . in one pc Aria login , and another Shahin login. we have a form called order that only aria can see.
i want when aria send a order, at the same time shahin can see detail order in report format.

how can do this??
 

DavidAtWork

Registered User.
Local time
Today, 23:27
Joined
Oct 25, 2011
Messages
699
sm
do you have a 'date/time entered' field for the order, if so you can create a report to run off the order table where this date = Date()
All you need now is a way of notifying second user that the record count in the order table has increased and then he can run report to see new order(s). You can do this by having a hidden text field on second user's database, text1 that holds the current order table recordcount. You need to link checking the order count to an event that happens in your database regularly, maybe the OnCurrent event of your main form, any event really that occurs often. Use If DCount(orderID,tblOrders) > text1 Then text1 = DCount(orderID,tblOrders), MsgBox "There is a new order" and give user the option to open the report.
You may also be able to link the DCount check to a Timer function

David
 

Users who are viewing this thread

Top Bottom