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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hamed NasrRetired IT ProfessionalCommented:
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
Hamed NasrRetired IT ProfessionalCommented:
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
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

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
Hamed NasrRetired IT ProfessionalCommented:
Modified labels, in red, moved to next month, showed discrepancy.
Labels back, displaying as expected!
marchaprilCalendar0.accdb
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
darls15Author Commented:
Thank you, I really appreciate your help with this.
0
Hamed NasrRetired IT ProfessionalCommented:
Welcome!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.