Top Contributors

Looking for beta testers

I decided to write a DatePicker replacement for the DateTimePicker control, since Microsoft no longer support it, the various solutions I found on the internet were nowhere near satisfying.

 Usage:
 - Reference DatePicker.d.accde
 - On a form, create a TextBox, with a Picture right next to it.
 - From VBA, instanciate a DatePicker object by calling the createDatePicker function, it require a TextBox and a Picture control as arguments.
 - Once you no longer need the instance, you must manually destroy it, by explicitly calling the Dispose method.

 Restrictions:
 - The form must not be modal.
 - Controls must be in the Detail section
 - The DatePicker class take control of the textbox and picture provided as arguments, so avoid messing up with these.
 - It also take control of the form's current event Handler, as well as the section Detail's mouseDown event Handler.
 - The class only support choosing a date, nothing was done about time.

 I provide 2 files:
 - a Test database, wich is a usage sample.
 - DatePicker.d.accde, a debug version, wich in case of error, will provide an error log in the execution window.

 Comments welcome.
Test.accdb
DatePicker.d.accde
View Previous CommentsLoad All Comments (9)
Rank: Prodigy

Expert Comment

Dale Fye2018-10-02 09:27 AMID: 2268153
Fabrice,

What version of Access was this written in?  I cannot seem to set a reference to the accde file when running A2007.

Dale
0
Rank: Wizard

Author Comment

Fabrice Lambert2018-10-02 09:32 AMID: 2268154
It is written with Access 2016.
0
Rank: Prodigy

Expert Comment

Dale Fye2018-10-02 10:34 AMID: 2268182
Can you compile it in 2007?  Would be far more useful for those who are working in 2007, 10, or 13.

Also, can it be used in both 32 and 64 bit Office, or do you have a separate version for each of those two versions of Office?
0
Rank: Wizard

Author Comment

Fabrice Lambert2018-10-02 11:16 AMID: 2268195
Nope, I don't have the luxury to own multiple version of access.


Guess I'll upload the ACCDB
DatePicker.accdb
0
Rank: Prodigy

Expert Comment

Dale Fye2018-10-03 07:33 AMID: 2268593
Fabrice,

I've tested it and it appears to work as expected.
0
Rank: Wizard

Author Comment

Fabrice Lambert2018-10-05 01:26 PMID: 2269732
Don't be afraid to run whataver tests you want, torture the Library at your liesure ;).

Also, it would be great if more ppl could test it.
0