If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Date changing 2028....2029......1930???????
I know exactly what your talking about, same as what other people said, I
just found it strange how there is a cut off at 2029 thats all. Thanks for the help you did give John W. Vinson wrote: Then you would have thought it would just stick to one and not change after 29 yrs I still think it is stupid :-) lol Think about it. Do you want 06 to refer to 2006? Sure. That's last year. Is it ok, then, to have 99 refer to 2099? Probably not; 1999 was only eight years ago. If you DO want all two-digit years to refer to 21st century dates, go for it: follow the instructions elsewhere in the thread. John W. Vinson [MVP] -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200703/1 |
#12
|
|||
|
|||
Date changing 2028....2029......1930???????
"David W. Fenton" wrote in message
. 1... "Douglas J. Steele" wrote in : Assuming you're using XP, go to Regional Settings in the Control Panel, and click on the Customize button. Look on the date tab, and you'll see what Windows is using as its instructions for interpretting 2 digit years. (It's there for other versions of Windows as well, but I can't guarantee that the instructions for finding it are identical) You can't really give instructions for WinXP any more for using Control Panel, because they introduced the ridiculously useless category view. In Win2K, you just open the Regional Settings tool and go to the Date tab. That's much simpler than your instructions. What, exactly, did MS think they were improving by making it more complicated in WinXP? (this is exactly why I've always rejected WinXP -- it adds complexity where none is needed, and tries to bleed it away (e.g., security) where it is essential) In the Category view, "Date, Time, Language and Regional Options" is one of the categories, and from there you can still choose the "Regional and Language Options" icon. (You're right, though, that I could have been more explicit, but like Rick I always switch to Classic View, so I sometimes forget about the "alternative" approach) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) |
#13
|
|||
|
|||
Date changing 2028....2029......1930???????
"Rick Brandt" wrote in
et: David W. Fenton wrote: "Douglas J. Steele" wrote in : Assuming you're using XP, go to Regional Settings in the Control Panel, and click on the Customize button. Look on the date tab, and you'll see what Windows is using as its instructions for interpretting 2 digit years. (It's there for other versions of Windows as well, but I can't guarantee that the instructions for finding it are identical) You can't really give instructions for WinXP any more for using Control Panel, because they introduced the ridiculously useless category view. In Win2K, you just open the Regional Settings tool and go to the Date tab. That's much simpler than your instructions. What, exactly, did MS think they were improving by making it more complicated in WinXP? (this is exactly why I've always rejected WinXP -- it adds complexity where none is needed, and tries to bleed it away (e.g., security) where it is essential) First thing I do on every XP box is switch Control Panel to "Classic View". Or are you referring to something else? Well, sure. I also switch the interface to Classic. And I turn on display of extensions and hidden files. And I turn off Simple Networking. And a whole host of other things that have the wrong settings in the default installation. But if you're giving instructions for how to do something with Control Panel, you have to realize that not everybody has the same view -- they may be using the default Category View. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#14
|
|||
|
|||
Date changing 2028....2029......1930???????
"Douglas J. Steele" wrote in
: "David W. Fenton" wrote in message . 1... "Douglas J. Steele" wrote in : Assuming you're using XP, go to Regional Settings in the Control Panel, and click on the Customize button. Look on the date tab, and you'll see what Windows is using as its instructions for interpretting 2 digit years. (It's there for other versions of Windows as well, but I can't guarantee that the instructions for finding it are identical) You can't really give instructions for WinXP any more for using Control Panel, because they introduced the ridiculously useless category view. In Win2K, you just open the Regional Settings tool and go to the Date tab. That's much simpler than your instructions. What, exactly, did MS think they were improving by making it more complicated in WinXP? (this is exactly why I've always rejected WinXP -- it adds complexity where none is needed, and tries to bleed it away (e.g., security) where it is essential) In the Category view, "Date, Time, Language and Regional Options" is one of the categories, and from there you can still choose the "Regional and Language Options" icon. (You're right, though, that I could have been more explicit, but like Rick I always switch to Classic View, so I sometimes forget about the "alternative" approach) I suspect that most of us who are answering questions here do the same thing. But we have to make our answers usable for the people who *don't* know the things we do! And that's extremely hard to remember how to dom in many cases. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#15
|
|||
|
|||
Date changing 2028....2029......1930???????
"evilcowstare via AccessMonster.com" u31650@uwe wrote in
news:6f7032b040017@uwe: I just found it strange how there is a cut off at 2029 thats all. Where would you want the cutoff to be? That is, how would you want your computer to guess what you mean? -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#16
|
|||
|
|||
Date changing 2028....2029......1930???????
"David W. Fenton" wrote in message
... I suspect that most of us who are answering questions here do the same thing. But we have to make our answers usable for the people who *don't* know the things we do! And that's extremely hard to remember how to dom in many cases. I generally focus on the answer to the question asked. "Change the setting in Windows Control Panel" If the poster doesn't know how to do that then that is a separate question. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#17
|
|||
|
|||
Date changing 2028....2029......1930???????
Well you would have thought that the people that designed access would have
put it in as an option, so you can decide where the years should start from yourself. So for example if you put 2001 then it would automatically change any date from that so if you put 30 it would know it would be 2030 not 1930. There seems to be lots of things access could have done to make life a lot easier. Oh well David W. Fenton wrote: I just found it strange how there is a cut off at 2029 thats all. Where would you want the cutoff to be? That is, how would you want your computer to guess what you mean? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200703/1 |
#18
|
|||
|
|||
Date changing 2028....2029......1930???????
It IS an option, not in Access itself, but in Windows.
As I've already said, you need to look at Regional Settings to change it. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "evilcowstare via AccessMonster.com" u31650@uwe wrote in message news:6f779c9d92e51@uwe... Well you would have thought that the people that designed access would have put it in as an option, so you can decide where the years should start from yourself. So for example if you put 2001 then it would automatically change any date from that so if you put 30 it would know it would be 2030 not 1930. There seems to be lots of things access could have done to make life a lot easier. Oh well David W. Fenton wrote: I just found it strange how there is a cut off at 2029 thats all. Where would you want the cutoff to be? That is, how would you want your computer to guess what you mean? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200703/1 |
#19
|
|||
|
|||
Date changing 2028....2029......1930???????
yeah i know its an option in windows but thats only good if its going to be
on just one pc, if it moves about then it would have been good to have something in access that you can set so that the db picks up on the settings you have chosen automatically Douglas J. Steele wrote: It IS an option, not in Access itself, but in Windows. As I've already said, you need to look at Regional Settings to change it. Well you would have thought that the people that designed access would have [quoted text clipped - 14 lines] That is, how would you want your computer to guess what you mean? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200703/1 |
#20
|
|||
|
|||
Date changing 2028....2029......1930???????
"evilcowstare via AccessMonster.com" u31650@uwe wrote in
news:6f77eba7ac2c5@uwe: yeah i know its an option in windows but thats only good if its going to be on just one pc, if it moves about then it would have been good to have something in access that you can set so that the db picks up on the settings you have chosen automatically But that's the whole point why you need to eliminate the problem by requiring 4-digit entry of years. You're quite right that you don't want the behavior of your application to change just because it's on a different PC, and when Y2K happened, I was among those who wished that there was a setting internal to Access for this. But MS is often not very smart about things they put in Access. For instance, Autocorrect (not Name Autocorrect, which is an abomination of another type) is a component shared between all the Office programs, and it's based on user-entered data. But Access defaults to Autocorrect being ON in all textboxes and combo boxes. It's not such a tragedy for textboxes, but it's the stupidest thing on the planet for combo boxes. I first encountered this in an app where a user was trying to choose an item from a dropdown list and when they chose it, the Access said "not a valid item from the list." Why? It was changing "cafe" as it was spelled in the dropdown text to "café" because that was an Autocorrect entry, and "café" wasn't one of the choices! So, sometimes MS's efforts towards "ease of use" conflict with the goals of a database program, where you want to insure the validity and accuracy of data. Because of that, you as a developer have to take responsibility for overriding these default MS configurations, which means you have to force 4-digit entry of years or write your own validation code, and you have to make sure you go through and turn off Autocorrect on all your dropdown lists. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
|
Thread Tools | |
Display Modes | |
|
|