Hi Javier It happens even if I make the date col the first col and custnum 2nd.
thanks marc --- Javier Valencia <[EMAIL PROTECTED]> wrote: > The record gets updated when you either leave the > row or save the record. > Since the date columns is the last column in the > table, when you press > ENTER, it saves the row and goes to the next row, if > you have only one row, > it will update (save) an and stay in the same row, > this is probably why you > see the year updated. > To have a date update right after you enter it, you > may try an EEP on exit > from the field that saves the row and redisplays the > row: > SAVEROW > RECALC TABLES > > Another trick that I use is to have an EEP on exit > from the field with the > following commands: > NEXTROW > PREVROW > It updates the display and gets you back to the same > row. > > Javier Valencia, PE > President > Valencia Technology Group, L.L.C. > 14315 S. Twilight Ln., Suite #14 > Olathe, KS 66062-4571 > (913)829-0888 > (913)649-2904 FAX > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On > Behalf Of marc schluter > Sent: Tuesday, August 27, 2002 5:24 PM > To: [EMAIL PROTECTED] > Subject: Re: Date in Forms > > Hi David, Bill, and Razzak > > Sorry, I was not very clear on my first post. > > I like having the date change to YYYY when I only > enter 05/05/02. > > The form that changes the date to 2002 has 2 tables. > The header table has Custnum and a date col in it. > This is the col that gets changed to 2002 as soon as > you leave the col. > > The other forms that do not change the date are 1 > table forms that have a custnum col and date col. > If > I add a 2nd table to one of these forms and add some > of the cols for the second table. The date changes > on > the first table as soon as you leave that field even > if you haven't gotten to the second tab yet. > > It in not a big deal, I just like the date changing > to > 2002. > > thanks > marc > > > --- Bill Downall <[EMAIL PROTECTED]> > wrote: > > I think marc is talking about something other than > > the date format > > issue. Marc, do you mean that if the user types > > 06/12/02, you want it > > _immediately_ to reformat itself to 06/12/2002? > On > > the region, as you > > move up and down through rows, the row is probably > > refreshing and > > redisplaying, but when you just tab through a form > > after entering it a > > date, it doesn't automatically refresh. You could > do > > this with a > > playback file that plays backs the keystrokes for > > the full date, or you > > could have an EEP execute a SAVEROW, which will > > redraw the > > dates. You could also set an expression that sets > a > > variable equal to > > the column, and another expression that sets the > > column equal to that > > variable, and it would refresh immediately. You > will > > have to play with > > the order of expressions and both edit and enter > > mode, and you will > > have to be sure that the form settings don't > assume > > they should make > > the field uneditable. Also, in a scrolling region > > this would be a pain, > > because you will get a "shadow" of the preceding > > row's variable value. > > > > vMyDate = DateCol > > DateCol = .vMyDate > > > > Bill > > > > > > On Tue, 27 Aug 2002 12:47:14 -0700 (PDT), marc > > schluter wrote: > > > > > have noticed that when I put a date in like > > 06/12/02 > > >some forms change the date to 2002 others do not > > >change the date. The only difference I can tell > > about > > >the form that changes the date is there is a > second > > >tab with a region on that form. I wish all of > the > > >forms changed the date to yyyy. > > > > > >Has anyone else noticed this or am I crazy. > > > > > > > > > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO > > rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to > > [EMAIL PROTECTED] > > In the message body, put just two words: > UNSUBSCRIBE > > rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO > rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to > [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE > rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO > rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to > [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE > rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
