duplicate values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

srn - 26 Mar 2008 21:34 GMT

Hi. My database records patient attendance on a daily basis. I have one form
to record patient number and it automatically records date and time, and
saves this info to an attendance table. I would like a message box to pop up
if the same patient number is re-entered on the same day i.e. to check the
attendance form for both the patient number and the date. If they are both
true then warn the user, and gve an option to continue to enter data - since
some patients can attend more than once, or cancel.
Regards stuart

Reply to this Message

Ken Warthen - 26 Mar 2008 22:17 GMT

SRN,

Does your form have a command button that must be clicked to write the
patient information to the attendance table? IF so, you can add some code to
the on_click event procedure to check the attendance table for the entered
patient number and current date.

> Hi. My database records patient attendance on a daily basis. I have one form
> to record patient number and it automatically records date and time, and
[quoted text clipped - 4 lines]
> some patients can attend more than once, or cancel.
> Regards stuart

Reply to this Message

srn - 26 Mar 2008 22:30 GMT

The IDsurname code is entered, this triggers date and time to be recorded
direct from the PC, I tab to a field recording another number and then click
on a command button to record the info to the attendance table. The newly
added record is then displayed along with all the other records for that day
on a subreport.

> SRN,
>
[quoted text clipped - 11 lines]
> > some patients can attend more than once, or cancel.
> > Regards stuart

Reply to this Message