Using Access to "call" an announcement form

  • Thread starter Thread starter Randy Wayne
  • Start date Start date
R

Randy Wayne

I would like to open an "announcement" form on a
receptionist PC when a client arrives. We use a Windows
Mobile 2003 PDA with a VB.net "smart application"t o check
the client in when they arrive at our service facility.
The PDA form accesses a SQL db and updates their vehicles
data. The client then goes into the reception area. How
could we have a message display on the receptionist's PC
based upon the arrival event in SQL.

The receptionist has Access 2000. Could we use this, or
is their a way to have the PDA "call" a form on another
(the receptionist's) PC?
 
If I understand you correctly, you could;

A) have Sql server send an Email to the receptionist when the database
is change in some manor you specify

B) develop an app (in access if you like, but could also be a vb.net app
as you obviously are familiar with it) to run on the receptionists
workstations that polls Sql every couple of seconds looking for a new
customer arrival.

Ron W
 
Ron:

Thanks for the reply.

I like your idea of a .Net app that polls the db. I will
give that a try.

I really appreciate you taking the time to read, think,
and write regarding this post.

Randy
 
Back
Top