List boxes multi-select

[Adzi]

Hi,

I'm regretting starting this project. It's such a pain!

Background:
I'm developing a campsite booking system for our large campsite. It works, I'm just enhancing it's usability now. The customer details are stored in tblCustomers with a customerID primary key. The actual pitch bookings are stored in tblCampsiteBookings with bookingReference and customerID as a compound key. Weekly, an append and deletion query runs, copying departed bookings from the tblCampsiteBookings to tblArchiveBookings and then deleting the record from tblCampsiteBookings. Effectivly tblCampsiteBookings should contain only current and future campsite bookings.

Problem:
We perform a morning check around 11am. By this time, some people have already left so I'm looking at implementing a "departure" feature where the user can select the already departed bookings using a multiselection list box and then the archive query is run and thus, the bookings dont appear on the report for the morning check. The list box stores the booking references for the output.

How can I return the values from the multiselect? Is this possible?

Thanks for any help!

Regards,
Adzi

 

[Galaxiom]

You are heading in the wrong direction.

You don't want to be archiving every time someone leaves. This involves copying records then deleting. Two step processes like this on large numbers of records can go wrong and you don't want to do this routinely on live data. Archive occasionally with a copy of the data backed up in case of mishap.

Just add a checkbox field to the main table for departed. It wouldn't matter a bit if you had ten thousand departed campers in your main table. You won't even notice the time it take for Access to choose the ones you want. Your form can be set to simply not display them unless required.