Well, I incorrectly stated that the listbox was bound. It is not. I
resolved this issue by using the form timer event and doing a
listbox.requery every minute. Sorry for any confusion.
Pat Randall wrote:
> 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!
|
Similar Threads
