P
Pat Randall
I have an Access 2K database (on file server) used to check in students
to our tutoring facility. As students are checked ‘in’, data is
collected and their name is added to a list box with the other students
who are currently checked in. The list box is bound to a transaction
table. When the student is ready to check ‘out’, double-clicking their
name in the listbox retrieves their record and they are checked out.
Their name is automatically removed from the listbox when their record
is saved.
Now, because of high demand, they plan to use two PCs for the student
check-in process. I need a way of refreshing these list boxes so they
are in sync with each other so that when a student is checked in using
the first PC, their name shows up in the listbox on the first PC as well
as the second PC.
(PC 1 and PC 2 would both be logging into the same database. No
front-end / back-end split yet.)
Any help appreciated!
to our tutoring facility. As students are checked ‘in’, data is
collected and their name is added to a list box with the other students
who are currently checked in. The list box is bound to a transaction
table. When the student is ready to check ‘out’, double-clicking their
name in the listbox retrieves their record and they are checked out.
Their name is automatically removed from the listbox when their record
is saved.
Now, because of high demand, they plan to use two PCs for the student
check-in process. I need a way of refreshing these list boxes so they
are in sync with each other so that when a student is checked in using
the first PC, their name shows up in the listbox on the first PC as well
as the second PC.
(PC 1 and PC 2 would both be logging into the same database. No
front-end / back-end split yet.)
Any help appreciated!