By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,656 Members | 748 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,656 IT Pros & Developers. It's quick & easy.

MS Access Calendar - First Day of Week

P: 17
I believe I read a post somewhere here on how to change the first day of the week to Monday in this MS Access Calendar, but is unable to search it up again. I've changed lines 5 and 8 in the quoted code (PopulateCalendar Sub-Routine, and by the way, line 4 seems to be missing a "/"?), and moved the day labels around. To my surprise, this is working so far. Is this all that is required? I'm a bit worried that I've overlooked anything.

Thanks for your time!

Expand|Select|Wrap|Line Numbers
  1. '*************************************************************************
  2.   'ADezii
  3.   'NOTE: Will work in the UK (United Kingdom) and other European Nations
  4.   'strFirstOfMonth = "1/" & Str(intMonth) & Str(intYear)
  5.   strFirstOfMonth = "1/" & Str(intMonth) & "/" & Str(intYear) ' PPelle added "/"
  6. '*************************************************************************
  7.  
  8. bytFirstWeekdayOfMonth = Weekday(strFirstOfMonth, vbMonday) ' PPelle added vbMonday
Dec 9 '13 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,607
Never actually thought of or attempted this, PPelle. Thanks for this useful Insight and addition, it is appreciated.
Dec 10 '13 #2

P: 17
Okey, thanks for your reply. I will assume than that this is all that is required. I have a few code lines that will actually use the system settings, automatically or by changing a constant. I can post it here if there is any chance you will include this in your code base.
Dec 10 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.