@moke123
Nice Job. I could not create something like that in a Month of Sundays , however I would point out that Xmas day is a Friday this year.?
Would this be the start day parameter that needs setting.?
@moke123
Nice Job. I could not create something like that in a Month of Sundays , however I would point out that Xmas day is a Friday this year.?
Would this be the start day parameter that needs setting.?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Not sure what you mean. 12/25/20 is a friday on the calendar. Did you get an error?
There are no parameters to set.
I should have probably indicated that you double click a date to input or edit an entry.
I just edited the original post to include that.
If this helped, please click the star * at the bottom left and add to my reputation- Thanks
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
For those who want to learn by my mistakes I originally used vbUseSystem for the day of week argument in the weekday function.
Since I'm in the U.S. it worked fine for me but gasman is in U.K. with a different system date format.Code:FirstDateOnGrid = FirstDate - Weekday(FirstDate, vbUseSystem) + 1
I've updated the original file I posted with a 1 for Sunday as the first day of week argument in the function.
Gasmans' modification used a constant to correct the UK system date to US format.Code:FirstDateOnGrid = FirstDate - Weekday(FirstDate, 1) + 1
Without seeing that it would have taken me a lot longer to spot my simple mistake.
Thanks for the assist my friend.
If this helped, please click the star * at the bottom left and add to my reputation- Thanks