Currency on user request

[perlfan]

Hi!

I would like to offer the user of my application the choice of which currency he wants to apply for bills etc.

From what I read so far I understand that the standard currency is taken from the regional windows settings. How can I now format my monetary fields in a way that they are dynamically presented in €, $ etc. formats according to the user's choice and ignoring the regional settings?

Thank you in advance for you help - Regards, Frank

 

[Galaxiom]

Maintain a table with exchange rates and express calculated values using lookups of this table as the Control Source.

No doubt there is some shell command that will retreive the local currency which you must compare with the table.

However it would be easier to allow the customer to select a currency from a combobox. You don't need to maintain such a large exchange table this way.

 

[perlfan]

Hi! I think u got me wrong. I don't want to convert currencies at all. A user should only be able to choose a standard currency and then get the responding symbol with it next to the monetary value.

How is that possible? I read something about doing that with a new format, but I have no clue how.....thx again in advance

Frank

 

[petehilljnr]

Just change the Format property of the controls displaying the values.

Go to a form / report, go to the properties on a text box control -> click in the Format field and press F1 - everything you need to know to define your custom number format will be there.

Create a table with your custom number formats, and a 'selected' option.
Then - on your form / report load event, change your controls properties to lookup the 'selected' option.

Pete

 

[gemma-the-husky]

i dont think you can have multiple active currencies.

if your regional setting is US dollars say, then if you want to display a value as UK sterling, then you would have to explicitly format it in that way.

 

[DCrake]

Using single or multiple currencies other than your native currency can lead to all sorts of issues, especially for historic data. As suggested you need to be able to apply a conversion rate to the net values as point of sale. This needs to be stored in the transaction table along with the currency type. This way when producing historic reports the gross value is the net value times the conversion rate. The exchage rate today will not be the same as it was last year. So in accountancy terms the billing amounts will not balance if you try to apply today's exchange rate.

David

 

[GaryPanic]

my 2 pence worth

insurance background


3 major currency
Sterling /Dollar/Euro

you can use any of the 3 major currencices and pay the markets in these currencies without any issue
other currencies can be used

OK - have a table with your currencies on it with Sysmbol and ISO code

USD/GBP/EUR
$/£/€
all in your table have them select this from a drop down
you might not need exchange rates depending on your business plan

Contract set up at the start of the year (or given period ) will have made up exchange rates-

your stats should bear this in mind -

however if you are going down a floating exchange rate then you need to do some serious think - if there is a time delay inbetween billing and being paid on a floating exchange rate then you will get differences plus or minus - there are solutions to his - but you need to get your accountants on board before you go down this route too far -


*Missed Davids post**