Is it possible to select several sequential dates in a calendar object?

**MMcCarthy** · May 11 '10, 02:44 AM

What kind of a calendar object are you using?

Is there a defined number of textboxes you need to use (e.g) a maximum of seven?

**ADezii** · May 11 '10, 12:59 PM

I may be able to accomplish this via the Custom Calendar Database that is frequently displayed here @ Bytes. Give me a little time to figure it out.

**Jo at Isla** · May 11 '10, 01:07 PM

I apologise for time delay - am currently in Isla Mujeres - Mexico! well away from my comp notes and software facilities :-( hence this forum and your kindness in communicating with me - for which i THANKYOU :-)

My head is buzzing with ideas but i am limited by the software available to the hotel ie MS Access 2003 and my memory!

I am using the calendar object in MS Access 2003 - this allows me to enter a room reservation start date and leave date. However i need to replicate a grid like view that will allow me to select a series of dates booked for a given hotel room. ie calendar dates to go across the top by 18 rooms down.

Being totally out of ideas with regard to MS Access (dont have vb6 with me) I am going to have a play in Excel ..... for this part of my proposed system build!

I am gifting the software build in repayment of accommodation kindness. Any ideas or directions that you can face me toward would be really appreciated...

**MMcCarthy** · May 11 '10, 01:13 PM

Originally posted by Jo at Isla

I apologise for time delay - am currently in Isla Mujeres - Mexico! well away from my comp notes and software facilities :-( hence this forum and your kindness in communicating with me - for which i THANKYOU :-)

My head is buzzing with ideas but i am limited by the software available to the hotel ie MS Access 2003 and my memory!

I am using the calendar object in MS Access 2003 - this allows me to enter a room reservation start date and leave date. However i need to replicate a grid like view that will allow me to select a series of dates booked for a given hotel room. ie calendar dates to go across the top by 18 rooms down.

Being totally out of ideas with regard to MS Access (dont have vb6 with me) I am going to have a play in Excel ..... for this part of my proposed system build!

I am gifting the software build in repayment of accommodation kindness. Any ideas or directions that you can face me toward would be really appreciated...

ADezii is going to look at the MS Access Calendar object for you.

This is an ingenious application he has put together which has been found to be very useful by many of our members. I'll leave you in his capable hands.

**Jo at Isla** · May 11 '10, 01:24 PM

Originally posted by ADezii

I may be able to accomplish this via the Custom Calendar Database that is frequently displayed here @ Bytes. Give me a little time to figure it out.

Thank you Adezzii - I was hoping that you would pick me up on this :-) If you are UK based then you are 6 hours ahead of me! Its 8.20am for me at time of posting.

I have used the MS Acess calendar object to allow a to and from date to be captured into text fields. I now need to look at how i can view rooms booked for a given set of calendar dates - everything else in my proposed build is well documented in memory as have done so many times before!

e.g Calendar dates across the top by 20 room numbers grid - within which i can select calendar dates booked for a given room.

All my previous builds have been wage, data analysis in orientation - first time of trying to build a calendar type aspect to a system - therefore very much appreciate your help in this regard.

**Jo at Isla** · May 11 '10, 01:26 PM

Originally posted by msquared

adezii is going to look at the ms access calendar object for you.

This is an ingenious application he has put together which has been found to be very useful by many of our members. I'll leave you in his capable hands.

thankyou :-)

**ADezii** · May 11 '10, 09:25 PM

I was unable to reproduce the exact functionality that you had requested with the Calendar Database, but I have created an Application that may/may not prove interesting to you. Only you can make that decision.

Download the Attachment that I have made available to you.
For this Demo, enter data directly into the tblBookings Table. Use the supplied Drop Down Menu for [Room_ID] (Room 1 to Room 20), enter a [Start Date] and [Leave Date]. These 3 Fields are required and cannot be NULL. I provided a limited amount of sample data for May only.
Open frmCalendar which will graphically display the data entered into tblBookings, and provide a visual cue as to which Rooms are occupied for any specific date on a monthly basis.
Left-Click on any date to display detailed information related to that date in the List Box below the Calendar. The information displayed will be: the Room ID, Room Name, Start Date, Leave Date, and the Duration (in nights), for the Room(s) displayed for the specific date chosen.

Since you are from the UK, you may experience some problems with dates and days being out of sync. Should this be the case, Uncomment Line #8 below, and Comment Line #3. This code can be found in the PopulateCalenda r() Procedure within frmCalendar.

Code:

'code above intentionally omitted

strFirstOfMonth = str(intMonth) & "/1/" & str(intYear)

'*************************************************************************
  'ADezii
  'NOTE: Will work in the UK (United Kingdom) and other European Nations
  'strFirstOfMonth = "1/" & Str(intMonth) & Str(intYear)
'*************************************************************************

'code below intentionally omitted

Do not modify any other portion of the code unless you know what you are doing.

Attached Files

Book Dates.zip (103.5 KB, 171 views)

**Jo at Isla** · May 12 '10, 03:57 PM

Wow :-)

Hi Adezzii thankyou so much for showing me the solution that you came up with - I was unable to enter data into the table part, and guessed that from there it would then show in a relevant calendar date/series of dates.

Is it possible for you to send me a copy that i can explore data entry with?

It looks to be perfect for what i am thinking of using it for :-) I totally understand about the UK date system, but I am designing/building this system for use by a small hotel run by mother/daughter in Mexico.

Knowing that this aspect is sorted! I will now look to build the other forms etc that will interact with the calendar form.

I look forward to receiving a working version

Regards
Jo

**ADezii** · May 12 '10, 04:18 PM

Originally posted by Jo at Isla

Hi Adezzii thankyou so much for showing me the solution that you came up with - I was unable to enter data into the table part, and guessed that from there it would then show in a relevant calendar date/series of dates.

Is it possible for you to send me a copy that i can explore data entry with?

It looks to be perfect for what i am thinking of using it for :-) I totally understand about the UK date system, but I am designing/building this system for use by a small hotel run by mother/daughter in Mexico.

Knowing that this aspect is sorted! I will now look to build the other forms etc that will interact with the calendar form.

I look forward to receiving a working version

Regards
Jo

Give me a little time, and I'll create a workable Demo that you allow you to enter data directly into the Bookings Table via a Form Interface, and isolate the Calendar functionality from that. Stay tuned...

**Jo at Isla** · May 12 '10, 04:49 PM

Your a star :-)

**ADezii** · May 12 '10, 08:09 PM

Originally posted by Jo at Isla

Your a star :-)

Here is a little something for you, have fun.
P.S. - I am leaving it up to you to write Validation Code to ensure that there are no 'Double Bookings' for a given Room. The combination of Room Number, and the Interval between the Start and Leave Dates for that Room, must be Unique!

Attached Files

Book Dates.zip (101.1 KB, 151 views)

**Jo at Isla** · May 12 '10, 08:39 PM

Hi Adezii

Thankyou so much for your help in this regard - it is really realy appreciated :-) Are you able to release the program to me so that i can embed it within the rest of the database system that i am building?

Warm regards

JO

**ADezii** · May 12 '10, 08:46 PM

Originally posted by Jo at Isla

Hi Adezii

Thankyou so much for your help in this regard - it is really realy appreciated :-) Are you able to release the program to me so that i can embed it within the rest of the database system that i am building?

Warm regards

JO

It is yours to do with whatever you like, thanks for asking.

**Jo at Isla** · May 12 '10, 09:32 PM

Dear ADezii, as i believe someone said to you earlier

You are a GENTLEMAN :-) xx