[X]My Assistant

[Gerrit]

In the process of finally getting shot of our dependence on the MSCAL.OCX in our machine shop management software. Originally the software was started in Access 97 and has been continuously upgraded. Users do not like the cumbersome and puny build in date picker in Access so I delved into my archive of Access samples and found a nice Date Picker pop up form dating back to 2011. Many thanks to the original creators for the sample.

Got it to work pretty good except I cant get the coding right to get the FireOffDateValue function attached to individual day buttons to work. Everything works fine if the OK button is used but ideally I would like to hide the OK button and use the day buttons to fire the date back to the primary form.

Am no coding wizard (more a UI and process flow designer) and wonder if someone could help with the final bit of coding.

We use mainly start and finish dates on data entry forms (Quotes, Job Sheets, Invoice Statements, etc.) to enable production scheduling. Typically on say a job sheet as per the attached screen grab.

Wohoo, my first ever post in UtterAccess.

Attached File(s)

 DatePicker.zip ( 114.21K )Number of downloads: 19
 JobSheet.jpg ( 301.33K )Number of downloads: 19

 

[Gerrit]

The DBGuy;

Perfect, worked 100% You are a legend, thank you.

Only 42 lines of code to highlight and paste in your code.

[theDBguy]

The DBGuy;

Perfect, worked 100% You are a legend, thank you.

Only 42 lines of code to highlight and paste in your code.

Hi. Glad to hear you got it to work. Good luck with your project.