Date Picker (1 Viewer)

isladogs

CID VIP
Local time
Today, 21:23
Joined
Jan 14, 2017
Messages
16,422
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
 
Last edited:

isladogs

CID VIP
Local time
Today, 21:23
Joined
Jan 14, 2017
Messages
16,422
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.
 

isladogs

CID VIP
Local time
Today, 21:23
Joined
Jan 14, 2017
Messages
16,422
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
 

Attachments

  • DatePicker_v1.4.zip
    69.8 KB · Views: 30

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 21:23
Joined
Jul 9, 2003
Messages
14,651

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:23
Joined
May 7, 2009
Messages
16,843
in UtterAccess there are lots also.
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 16:23
Joined
May 21, 2018
Messages
6,443
I tried to put them all into one place.

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

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 21:23
Joined
Jul 9, 2003
Messages
14,651
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.
I keep them behind a pay wall. You can circumnavigate the pay wall with coupon codes:-

The first Nifty Date Picker:-

Nifty Date Picker - MS Access​

Free with this coupon code:- bqu488f

Nifty Date Picker - Upgrade 3Month Display​

Free with this coupon code:- dp02rq1

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

This is a FREE "build it yourself" Date Picker


The VBA Code is Here:-
 

Users who are viewing this thread

Top Bottom