Is there a way to use a WatchDog???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JLuis Estrada - 26 Jul 2005 22:20 GMT

Hi!

I got the next doubt:

Im developing an Agenda. But I need to know if there's a way to have a
watchdog to update the table in anothe user.

i.e.

User #1 checks his schedule for today and at the same time user #2
checks the schedule of the user #1 of the same day (today). User #1 set a
new entry at 12:00 and what I would like is that the user #2 view the change
just before it was made, whitout the use of a "reload" button.

Is this possible???

Somebody recommended me the use of winsock and UDP, but I guess is
another way to solve it.

Hope you can help me.

JLuis

Reply to this Message

John Vinson - 26 Jul 2005 23:54 GMT

> User #1 checks his schedule for today and at the same time user #2
>checks the schedule of the user #1 of the same day (today). User #1 set a
>new entry at 12:00 and what I would like is that the user #2 view the change
>just before it was made, whitout the use of a "reload" button.

Is this "schedule" in a Microsoft Access database? or are you talking
about Microsoft Outlook? If so, please repost your question in an
Outlook newsgroup.

If it's in Access, what's the structure of your database? Are the
users checking schedules on a Form bound to a shared backend table, or
what?

John W. Vinson[MVP]

Reply to this Message

JLuis Estrada - 27 Jul 2005 15:03 GMT

Well, this schedule is programmed in VB with an Access table.

Theres a DB with a table named "Agenda", In there, I got the next
structure:

ClvAge Str MD ID
ClvPac Str Patient ID
Des Str Description of the entry
FecCit Date Date of the entry
HorInic Date Start time of the entry
HorFin Dat Finish time of the entry
Pri Int Priority of the entry
Asi Bool Did the patient assist to the date?

In this table I save all the dates for any doctor.

But this is the main case:

The Doc #1 open his schedule fo today and he got no-date in it -is
empty-. Meanwhile at the same time his assistant open the schedule in
another PC for the same doc -#1- and Add a new date to the schedule.
So, what I want is reflect the changes in the Doc's PC just after the
assistant made the new entry.

Access got something like a watchdog to force the reload of the Doc's
display or I have to develop it????

>> User #1 checks his schedule for today and at the same time user #2
>>checks the schedule of the user #1 of the same day (today). User #1 set a
[quoted text clipped - 11 lines]
>
> John W. Vinson[MVP]

Reply to this Message