Date Picker

[isladogs]

Posts crossed

The left one

That one is Sun to Sat on my PC. I need to check why the days are shifted by one on your machine.

Your formatting code is very simple and it works. I had tried something more convoluted and it didn't work
I've changed the out of months days from dark red to dark grey

NOTE: Its a deliberate decision to only show the required number of weeks for each month but, of course, you are free to modify as you wish.
However, I'm concerned that the days differ on your machine and mine. Will investigate when I have time

 

[KitaYama]

I need to check why the days are shifted by one on your machine.

I don't think the days are shifted on my machine.
According to Microsoft documentation vbSunday returns 1.
Why for you 7 is Sunday?
Me.Label19.Caption = WeekdayName(7, True)

Weekday function (Visual Basic for Applications)

Office VBA reference topic

docs.microsoft.com

 

[isladogs]

Oops. My error.
I've just discovered the problem in v2206. I had hard coded vbSunday.
In fact I only need one version using this approach

Change vbSunday to vbUseSystemDayOfWeek in DrawDateButtons

I'm going to do more testing and will upload a fixed version later.

However, we've hijacked this thread. Please can any further exchange be done via private message or email.

 

[KitaYama]

However, we've hijacked this thread

My apologies to OP. I'm terribly sorry.
PM is on.

 

[isladogs]

I've now fixed the errors in the versions originally uploaded to post #11 and added extra functionality

The main changes in version 1.4 include:
a) First day of week now automatically assigned according to Windows settings - no need for multiple versions
b) Out of month days added in dark grey
c) Following month days only shown if in same week as last day of current month
d) Selecting an out of month day assigns the correct month automatically. Also tested successfully for dates selected in previous year or following year
e) Clicking the Today button resets the calendar to the current month/year & highlights current date ready for selection to confirm
f) Added Mendip Data Systems link to date picker form as suggested by @KitaYama

I will also post this version to sample databases and my website later

Many thanks to @KitaYama for suggesting several additional features & for testing the new version

 

[Uncle Gizmo]

We prefer to be able to see and select dates from the end of previous month or the first days of next month.

So do I...
I have that in my original date picker:-

Nifty Date Picker – Original - Nifty Access

Nifty Date Picker - Original This Page is about the original "Nifty Date Picker" from Nifty Access - The NEW updated version of the "Nifty Date Picker" has some really cool extra features and can be found at this link here:- "Nifty Date Picker" - Updated More Links in the DATE MENU Below! There are

www.niftyaccess.com

The latest version is here below, and shows 3 months. It's based on the single month version, so can be a tad slow to load...

Nifty Date Picker - Nifty Access

Nifty Date Picker -Updated This page is about the new "Nifty Date Picker" which supersedes the old original "Nifty Date Picker". If you're looking for the original "Nifty Date Picker", just click THIS LINK and you will be taken to the webpage. The new "Nifty Date Picker" has some Nifty New...

www.niftyaccess.com

 

[KitaYama]

I have that in my original date picker:-

I didn't know you have a date picker too.
I'll check it out.
thanks

 

[arnelgp]

in UtterAccess there are lots also.

 

[MajP]

I tried to put them all into one place.

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

I updated that thread with @isladogs and @arnelgp current datepicker.

 

[Uncle Gizmo]

I didn't know you have a date picker too.
I'll check it out.

Good to know!
All my date pickers run on my own code written from scratch.

Nifty Date Picker - For "ALL" Versions of MS Access​

This is a FREE "build it yourself" Date Picker

The VBA Code is Here:-

Nifty Date Picker – Original - Nifty Access

Nifty Date Picker - Original This Page is about the original "Nifty Date Picker" from Nifty Access - The NEW updated version of the "Nifty Date Picker" has some really cool extra features and can be found at this link here:- "Nifty Date Picker" - Updated More Links in the DATE MENU Below! There are

www.niftyaccess.com

 

[Renny09]

Thanks for sharing the coupons. they were useful to me. I'want to add that recently I fount the info how to create this coupons and discounts without great knowledge. I think it's worth to see.