Bill, Also, you might investigate the flexibility of my 100% RBase form calendar. Here's the link and example code:
http://www.byerley.net/(S(diznwqreqoyizi5510uwcxve))/Download_A/RbCalendar.z ip > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Bill > Downall > Sent: Thursday, December 19, 2013 8:11 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Help me brainstorm: DateTimePicker and eeps > > Thanks Razzak, Albert, David, and all! I'm on the right track now. > Using the Enhanced DB Calendar didn't quite get me there, but the > Variable controls seem to be doing it. > > Bill > > > On Wed, Dec 18, 2013 at 2:00 PM, Albert Berry <[email protected]> > wrote: > > > How about a stored procedure ON CLICK? Razzak's idea is probably > better, though. > Albert > > > On 12/18/2013 11:00 AM, Bill Downall wrote: > > > Albert, > > A trigger would work for the checking, but the problem is > how to trigger the trigger upon changing data in the field. > > Bill > > > On Wed, Dec 18, 2013 at 12:45 PM, Albert Berry > <[email protected]> wrote: > > > Bill, could you perhaps create a trigger with the > checks in it? > I'm thinking something like > - Get the new value > - Get the PK of the row > - Get the old value and whatever else you need to > know > - do the valid/invalid change checks > - abort trigger or let it run > - in the trigger if the change is aborted, quick note > to user and return to the picker > > Albert > > On 12/18/2013 9:19 AM, Bill Downall wrote: > > > Hi, all, > > I'm needing a strategy that I'll bet some of > you have solved. > > I want to do some date checking whenever a user > makes a change to a date. > > Unlike text-based controls, a DateTimePicker > does not have an "on Exit" eep. Mousy users might not move to the > "next" field on the form, but could jump anywhere. They could even > close the form while the cursor is still on the date field. > > The on-click/ and on-double-click eeps trigger > before they make the change I care about. > > Table eeps: on leave section, on row exit, are > too late to check and pop-up necessary dialogs for users. > > What would you do? Thanks. > > Bill > > > > > > --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
