Access calendar database dates placed incorrectly

Hi Experts

I found a calendar/events database on the Internet which I would like to adapt and use. There's only one problem - the dates aren't appearing on the calendar correctly. For example, 17th March is showing as Monday and it should be Tuesday. Other calendars (April, May etc.) are also wrong. I have no idea how to fix this in the code and would appreciate any assistance in getting it right. And is there a way to stop it from constantly blinking at every second change?

Thanks
darls15
Calendar.accdb
darls15Asked:
Who is Participating?
 
hnasrCommented:
Modified labels, in red, moved to next month, showed discrepancy.
Labels back, displaying as expected!
marchaprilCalendar0.accdb
0
 
hnasrCommented:
I ran the database and it gave a correct result for the date mentioned.
Labels are static starting Sunday.
0
 
darls15Author Commented:
Hi,

I just ran it again to be sure and have attached a screenshot of how it displays for me. March 17 is shows under the Monday header and not Tuesday. April dates are also way out.

Do you have any further advice?

Thanks
darls15
CalendarScreenshot.PNG
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
hnasrCommented:
From the image you uploaded, I suspect the day labels as they are static. They are not used anywhere in the code.

Try to modify them to start from Monday, and report back.
0
 
Gustav BrockCIOCommented:
This is just another example of sloppy code. Dates are sometimes string handled like here:

bytFirstWeekdayOfMonth = WeekDay(strFirstOfMonth)

And the weekday lables are hardcoded.
If you  move the Monday label to the first position and rearrange the others, it may work.

/gustav
0
 
darls15Author Commented:
Hi

Thank you for getting back to me. I've tried your suggestions of moving the labels to the first position. This fixes the calendar for March, however when I move to April, the days and dates do not align. Please see attached screenshot.

I'm don't know how to alter the code to fix this and would appreciate any assistance.

Many thanks
darls15
0
 
darls15Author Commented:
Sorry, the screenshot...
darls15
April.PNG
0
 
Gustav BrockCIOCommented:
Oh. The reason is that the code is very US centric, ignoring International standards. It could be recoded but that might be a major work.
I'm confident I could do it, but I don't have the time neither the need. Sorry.

/gustav
0
 
darls15Author Commented:
Thank you, I really appreciate your help with this.
0
 
hnasrCommented:
Welcome!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.