UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Coding Help For New Date Picker Pop Up Form, Access 2010    
 
   
Gerrit
post Oct 18 2019, 12:00 PM
Post#1



Posts: 12
Joined: 12-October 19



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)
Attached File  DatePicker.zip ( 114.21K )Number of downloads: 19
Attached File  JobSheet.jpg ( 301.33K )Number of downloads: 19
 
Go to the top of the page
 
 
Start new topic
Replies
Gerrit
post Oct 18 2019, 04:05 PM
Post#2



Posts: 12
Joined: 12-October 19



The DBGuy;

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

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

hat_tip.gif
Go to the top of the page
 
theDBguy
post Oct 18 2019, 09:45 PM
Post#3


UA Moderator
Posts: 76,793
Joined: 19-June 07
From: SunnySandyEggo


QUOTE (Gerrit)
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.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    5th December 2019 - 05:02 PM