Regional Settings Currency Format - Microsoft Access / VBA

Bob Dydd

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
with Regional Settings Currency Format set to US $ or AUS $ it
retains the UK £'s format.

Microsoft has something to say about this but does not offer any
further help on this subject.
http://support.microsoft.com/default...8596#appliesto

I am looking for a way to format currency fields according to the
regional settings of whatever machine the mdb is used on.

I could of course do away with the $ and £ signs altogether, but that
would be the cowards way out ;-)

Any help or pointers appreciated.

Regards Smiley Bob

Nov 13 '05 #1

Subscribe Reply

4557

MGFoster

I believe you have to compact the .mdb on a computer that has the
destination's regional settings.

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Bob Dydd wrote:

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
with Regional Settings Currency Format set to US $ or AUS $ it
retains the UK £'s format.

Microsoft has something to say about this but does not offer any
further help on this subject.
http://support.microsoft.com/default...8596#appliesto

I am looking for a way to format currency fields according to the
regional settings of whatever machine the mdb is used on.

I could of course do away with the $ and £ signs altogether, but that
would be the cowards way out ;-)

Nov 13 '05 #2

Michael $michka$ Kaplan [MS]

Compact does not change this.

It is entirely intended and by design. If you want to have this prop follow
the regional settings then you must have code modify all of the Format
properties in the app.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.
"MGFoster" <me@privacy.com > wrote in message
news:rl******** **********@news read1.news.pas. earthlink.net.. .

I believe you have to compact the .mdb on a computer that has the
destination's regional settings.

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Bob Dydd wrote:
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
with Regional Settings Currency Format set to US $ or AUS $ it
retains the UK £'s format.

Microsoft has something to say about this but does not offer any
further help on this subject.
http://support.microsoft.com/default...8596#appliesto

I am looking for a way to format currency fields according to the
regional settings of whatever machine the mdb is used on.

I could of course do away with the $ and £ signs altogether, but that
would be the cowards way out ;-)

Nov 13 '05 #3

Similar topics

7174

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

1917

Doubt in Regional Options

by: Cesar Ronchese | last post by:

Hello All! I have a .Net project that, in my machine, the dates are showed in this format: dd/mm/yyyy. But, when I install the project in some customer machines, the date is showed in this format: dd/mm/yyyy hh:mm:ss. My doubt is, I can resolve this problem on which form? a) changing the Windows Regional Options b) setting the Internationalization classes of my AppDomain

.NET Framework

4844

Change in Short Date format under Hebrew Regional Settings

by: Laurence Neville | last post by:

This is regarding a change in the Short Date format under Hebrew Regional Settings, that has caused huge problems in our ASP web application. The change appears to have been introduced sometime before Windows 2000 Service Pack 4 and has remained through to Windows XP. I am looking for a solution that doesn't involve rewriting our application (much) and that allows all our users to keep using Hebrew Regional Settings. To summarize our...

ASP / Active Server Pages

15843

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, this does not seem to be working in IIS6, in that I have

ASP / Active Server Pages

2382

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 static void main(String args)

C# / C Sharp

5237

Regional independant Format() with dots-comma's

by: Sick | last post by:

My application populates a ListBox from a .TXT file. In the textfile there are prices with both dots as well as comma's for decimal indication. Example: 1234990; xg-tr-45; 1700,50; 0 2662666; hj-54-56; 1565.00; 0 8228880; 30-56-tw; 3295.50; 0 0022339; hs-sa-73; 2975,75; 0 .... etc

Visual Basic .NET

3327

Problem with regional date settings

by: Schfooge | last post by:

I am trying to do a homework assignment, but I am having troubles due to regional date settings. Part of the program requires a date to be read from a sequential file, which gives the date in string format. The program needs to convert the string to a date. However, the text file supplied is in US formatting (eg. "07/24/2001" for July 24,2001 but my computer's settings are Canadian (24/07/2001"). Now I know that

Visual Basic .NET

12637

Regional settings and date format problem

by: Fred Flintstone | last post by:

I'm writing a VB.Net windows forms application. This line of code: Personal.EffectiveDate = GridRow2.Cells("New Value").Value.ToString.Trim Fails with this error: Cast from string "8/23/2005" to type 'Date' is not valid. The date being returned is in US English and my system is set for

Visual Basic .NET

2929

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 and build it with my old machine, it still crashes. I thought maybe it was the code, but it...

Visual Basic .NET

8752

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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9257

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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8097

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6702

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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6011

Couldn’t 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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4519

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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4784

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

3221

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

2157

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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General