producing a range in a calendar

[riaj]

hi,
i'm designing a villa booking database where the user will be able to use the calendar in Access to select dates. I can use it to select 2 dates it just won't get all of the dates between the two!!
does anyone know how I can get it to do this to help prevent double bookings?

ri

 

[nicsin]

Can you give an example of what you are trying to do and also where do you face the problem?

 

[riaj]

i want the user to select a start date, then end date, which I can do but I then want it to mark both of those dates and the ones in between as taken for that particualr villa. There are 13 villas.

ri

 

[nicsin]

In order to help you, we have to know some more details about what you are doing like what's already been done (any forms, queries etc), what is your development environment (access/vba, vb, something else).

 

[riaj]

i'm using access and I have designed a booking form, customer form and I have tables according to this. However, I would like to use the MSCAL I think its called. I am currently using this calendar to select a start date and then find an end date if I input the amount of days,( i've done this using VB), however, i want it to select the dates in between as well.