Home Posts Topics Members FAQ
Mark
Hi All,
By default, our machines regional settings are set to US which causes
problems with date formats until they are manually changed to UK. Is there
any way to set the regional settings to UK when the database is opened?
We work with the format dd/mm/yyyy not mm/dd/yyyy
OS = XP pro
Access Version = 2002 SP3
TIA
Mark
Nov 13 '05 #1
Subscribe Reply
3 
1779 
David Schofield
On Mon, 21 Mar 2005 15:52:40 GMT, "Mark" <ma**********@n tlworld.com>
wrote:
Hi All,
By default, our machines regional settings are set to US which causes
problems with date formats until they are manually changed to UK. Is there
any way to set the regional settings to UK when the database is opened?Can't answer this one but ----
We work with the format dd/mm/yyyy not mm/dd/yyyy
----- if you use a date in an SQL string, it MUST be in US format, ie
mm/dd/yyyy.
If you need a date in code you can always use an alpha format eg
CDate("1 January 2005") which is the safest in my opinion.
I think the web site of one of the regulars has some handy tips on
using dates in Access but I can't lay my hands on it at present.
David
Nov 13 '05 #2
David Schofield
PS:
http://allenbrowne.com/ser-36.html is what I was thinking of.
David
Nov 13 '05 #3
Trevor Best
David Schofield wrote:
If you need a date in code you can always use an alpha format eg
CDate("1 January 2005") which is the safest in my opinion.
Strictly in code, not for outside world though. I once thought I was
safe exporting dates with the month spelt but was caught out when my
client was running it and the dates came out with the month names in
Turkish. The other end trying to import the data was a bit miffed :-)
--
This sig left intentionally blank
Nov 13 '05 #4
This thread has been closed and replies have been disabled. Please start a new discussion.
Similar topics
| 4 10027 Changing Java's regional setting by: Grumfish |last post by: Is there a way to tell Java what localization to use so applications and the compiler doesn't default to the system's setting? I'm using a computer with Windows 2000 with a regional setting of Japanese. Is there any way to have Java always use US English rather than the default Japanese? Java |
| 1 7154 regional settings by: nerman |last post by: Hello I have a problem with the regional settings. I have set the regional settings of the web server to display the numbers in this format 123.456,78 But when I open my web site all number are diplayed with the old format which is 123,456.78 I changes also the regional setting of my computer but it does not work any ideas Thank Nere ASP / Active Server Pages |
| 4 15837 Regional settings in IIS6 by: Jonathan |last post by: Dear All, I am trying to set a webserver to use French regional settings for testing ASP pages. According to http://support.microsoft.com/kb/q306044, for IIS5, this is a matter of changing the regional settings for the authenticated user, and if this user does not have a user profile then the default regional settings. Unfortunately,... ASP / Active Server Pages |
| 2 4541 Regional Settings Currency Format by: Bob Dydd |last post by: Hi Everbody Question Changing the regional settings ie. from UK to US AUS etc, Access retains the original currency format that the application was created in. So if an mdb that is written on a computer with Regional Settings Currency Format set to UK £'s , when that mdb is open on a machine Microsoft Access / VBA |
| 3 12390 How do I read user's regional settings ? by: Emmanuel |last post by: I want to know the decimal separator and the group separator character that the user has set in Regional Settings in Control Panel. I tryied to use System.Globalization.NumberFormatInfo.CurrentInfo like that: NumberFormatInfo numInfo = System.Globalization.NumberFormatInfo.CurrentInfo; string ds = numInfo.CurrencyDecimalSeparator;... C# / C Sharp |
| 1 2368 C# vs. J# String behavior with non-US regional settings by: John |last post by: Hi, The following behavior when using J# vs. C# is really bothering me. When I have the regional settings on my workstation set to a non-US settings (eg: Danish); it seems that J# disregards the regional settings. Where-as C# automatically picks up the regional settings and applies them. For example, the following J# code: public... C# / C Sharp |
| 12 9109 Regional Settings en-GB CultureInfo.CurrentCulture.Name = en-US by: magister |last post by: Hello, I know I can set the Culture to what I want, but shouldn't the current culture be taken from the regional settings on the web server's control panel!!! Mine is set to "united kingdom" but in my asp.net page I do ASP.NET |
| 16 2916 Regional settings cause runtime crash by: Colmag |last post by: I've written an application with vb.net 2003 (framework 1.1) which automates a 3rd party viewing/printing application (via an activex control). I've released several versions over the last year without problem, but since getting a new laptop, people can't run the program since I built it with the new machine. Even if I take the modified code... Visual Basic .NET |
| 1349 modifying regional and language settings programatically in vb.net by: arunbojan |last post by: Hi friends, i know how to retrive the regional and language options of control panel in vb.net Eg: CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern() my question is, how to modify the regional and language settings of control panel programatically in vb.net.... .NET Framework |
| 7444 Changing the language in Windows 10 by: Hystou |last post by: Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language... Windows Server |
| 7954
Maximizing Business Potential: The Nexus of Website Design and Digital Marketing by: jinu1996 |last post by: In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that... Online Marketing |
| 1 7467 The easy way to turn off automatic updates for Windows 10/11 by: Hystou |last post by: Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For... Windows Server |
| 1 5367
Access Europe - Using VBA to create a class based on a table - Wed 1 May by: isladogs |last post by: The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes... Microsoft Access / VBA |
| 5085 Couldnt get equations in html when convert word .docx file to html file in C#. by: conductexam |last post by: I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert... C# / C Sharp |
| 3497 Trying to create a lan-to-lan vpn between two differents networks by: TSSRALBI |last post by: Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in... Networking - Hardware / Configuration |
| 3478 Windows Forms - .Net 8.0 by: adsilva |last post by: A Windows Forms form does not have the event Unload, like VB6. What one acts like? Visual Basic .NET |
| 1 1932 transfer the data from one system to another through ip address by: 6302768590 |last post by: Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system C# / C Sharp |
| 755
Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy by: bsmnconsultancy |last post by: In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating... General |
By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.
To disable or enable advertisem*nts and analytics tracking please visit the page.
