Calendar Control (1 Viewer)

[zezo2021]

Thank you in advance

I have a form with Calendar Control and textbox txtStartDate and textbox txtEndDate

I want to send these dates in txtstartdate textbox and txtEndDate textbox ranges to Calendar Control and the other slots be blank if no dates in this range

is this possible

Thank you in advance

 

[MajP]

Yes, I am sure it can be done, but not exactly sure what you are asking. What type of calendar control are you using? A screen shot or an uploaded db could help get an answer. There are a ton of examples of home grown controls to expand the limitations of some of the built in controls. A few here.

Date Pickers, Calendar Controls, and Calendar resources

There has been some recent interest in a replacement for the MS calendar control that existed prior to 2010. I have been collecting date pickers, calendar controls, and calendars for a long time and thought it would be a good idea to have one thread with lots of good examples. Some of these...

www.access-programmers.co.uk

 

[zezo2021]

Yes, I am sure it can be done, but not exactly sure what you are asking. What type of calendar control are you using? A screen shot or an uploaded db could help get an answer. There are a ton of examples of home grown controls to expand the limitations of some of the built in controls. A few here.

Date Pickers, Calendar Controls, and Calendar resources

There has been some recent interest in a replacement for the MS calendar control that existed prior to 2010. I have been collecting date pickers, calendar controls, and calendars for a long time and thought it would be a good idea to have one thread with lots of good examples. Some of these...

www.access-programmers.co.uk

user input dates in the Start date and End Date buttons show dates ranges on cal

 

[zezo2021]

 

[MajP]

Most of the modern calendar controls for things with to from dates, like airlines lets you pick the range at one time. This can be done, but I do not think any of those examples I posted do it. Something like this from the airline. I keep meaning to build one, but I am sure if you google you can find one.

 

[MajP]

Here is one problem. You are using MSCAL control which is no longer supported (for a very long time now. I believe since Access 2007). I cannot open this. This is another reason people roll their own calendar controls. Not sure why MS did not replace it with something else. Or if they did I do not know about it.

If this works for you can you post a screen shot.
Is the range likely to be a short like a couple of days, a couple of months? A year? This would dictate the view.
I think this can be done by rolling your own solution.

I will see if I can demo. You just want to highlight the range like image above?

 

[zezo2021]

Here is one problem. You are using MSCAL control which is no longer supported (for a very long time now. I believe since Access 2007). I cannot open this. This is another reason people roll their own calendar controls. Not sure why MS did not replace it with something else. Or if they did I do not know about it.

If this works for you can you post a screen shot.
Is the range likely to be a short like a couple of days, a couple of months? A year? This would dictate the view.
I think this can be done by rolling your own solution.

I will see if I can demo. You just want to highlight the range like image above?

I have example work and good but I have 2 Problem form availability
dates not in the right position
I need to next or the previous month
can you edit the code to reflect these changes
just select a date from the subform
specially 7/26/2025 and 7/27/2025
compare these above dates with the calendar you see them at top but should be bottom

 

[MajP]

Since your ranges are pretty large would you be interested in a bigger view to avoid scrolling to other months? I have all the code for this. Just need to strip stuff out.
This is actually showing multiple events so it would just be limited to a single event. The labels tell you what type of event and that could be made blank.

 

[zezo2021]

I have example work and good but I have 2 Problem
dates not in the right position
I need to next or the previous month
can you edit the code to reflect these changes
just select a date from the subform
specially 7/26/2025 and 7/27/2025
compare these above dates with the calendar you see them at top but should be bottom

I need some one help me edit my code

 

[Mark_]

I need some one help me edit my code

Please post your code, what you expect it to do, and what it is/isn't doing. If it generates an error, please post that also.

 

[zezo2021]

Please post your code, what you expect it to do, and what it is/isn't doing. If it generates an error, please post that also.

I have example work and good but I have 2 Problem in the form availability
dates not in the right position
I need to next or the previous month
can you edit the code to reflect these changes
just select a date from the subform
specially 7/26/2025 and 7/27/2025
compare these above dates with the calendar you see them at top but should be bottom

 

[MajP]

How about this? Since you have large ranges.

 

[zezo2021]

Since your ranges are pretty large would you be interested in a bigger view to avoid scrolling to other months? I have all the code for this. Just need to strip stuff out.
This is actually showing multiple events so it would just be limited to a single event. The labels tell you what type of event and that could be made blank.
View attachment 119241

can I set the range for this calendar

 

[zezo2021]

How about this? Since you have large ranges.
View attachment 119244

please send to me the example
thank you so much

 

[zezo2021]

 

[zezo2021]

How about this? Since you have large ranges.
View attachment 119244

?

 

[MajP]

can I set the range for this calendar

Not sure what you mean. It is set up for display and not as a to/form date selector. If you are asking can you pick how many months to show at a time the answer is no. You could spend the time and make a 2,3,6 month display. It would not be hard, but would be a little tedious.

There is a bug, that I need to fix. It should allow you to go to another year and display the dates for that year if they extended beyond a single year. In my test it loads the next years dates but immediately clears them out. Same if you move off the current year and back. Your example only had dates in a single year so it was not really an issue.

 

[zezo2021]

Not sure what you mean. It is set up for display and not as a to/form date selector. If you are asking can you pick how many months to show at a time the answer is no. You could spend the time and make a 2,3,6 month display. It would not be hard, but would be a little tedious.

There is a bug, that I need to fix. It should allow you to go to another year and display the dates for that year if they extended beyond a single year. In my test it loads the next years dates but immediately clears them out. Same if you move off the current year and back. Your example only had dates in a single year so it was not really an issue.

Thank you sir
Appreciate your help

 

[MarkK]

For a contiguous range of dates you only need the start and the end. This could be implemented using just two navigable month view calendars, one for each data point.

 

[MajP]

If interested this has some fixes so you can display dates across the years. Need to replace the whole subform.

So the first record goes from 4/3/2024 to 2/6/2025
You can use the year selector to show any year's dates.
2024

2025