G
Guest
i have downloaded the orders database and some other templates but need to
change the currency.
change the currency.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Al Campagna
symbolrate,
You can set the format for your currency field in the table for that data, or... you
can Format the numeric field as Currency on whatever form you have.
You can set the format for your currency field in the table for that data, or... you
can Format the numeric field as Currency on whatever form you have.
J
Joseph Meehan
symbolrate said:i have downloaded the orders database and some other templates but
need to change the currency.
Do you mean you want to change values stated in Euros to Dollars? Or
do you want to change ? symbols to £ or $
G
Guest
Joseph Meehan said:Do you mean you want to change values stated in Euros to Dollars? Or
do you want to change ? symbols to £ or $
--
Joseph Meehan
Dia duit
Yes need to make the default currency in the dbase to £.
G
Guest
Al Campagna said:symbolrate,
You can set the format for your currency field in the table for that data, or... you
can Format the numeric field as Currency on whatever form you have.
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
Thanks , I will try that, never worked with Access so will have a go on that. I actually have the database I need in Lotus approach but I presume it is easier to import the data as csv than try and convert the database. So will try your suggestion.
J
Joseph Meehan
Access reads that from the Windows regional settings. You can find that
in the Windows Control Panel.
in the Windows Control Panel.
G
Guest
Access reads that from the Windows regional settings. You can find that
in the Windows Control Panel.
--
Joseph Meehan
Dia duit
That's what I thought, mine of course is set for UK and the £ Pound sign is set. However when I run the template, it still shows $ so as somebody else said will try to re-set in the tables.
J
Joseph Meehan
Where does the $ show? If it is simple text somewhere, it will not be
changed by the regional settings. It would be a simple edit. Of course you
have to figure out where it is coming from, stored data, a label ???
changed by the regional settings. It would be a simple edit. Of course you
have to figure out where it is coming from, stored data, a label ???
J
Joseph Meehan
I just thought of something else. It may be coming from combining text
with data form something like
"$ " [Your Field Name]
Your Field Result of formula above
56 $ 56
12348 $ 12348
Using a simple label would more likely provide
56 $ 56
12348 $ 12348
with data form something like
"$ " [Your Field Name]
Your Field Result of formula above
56 $ 56
12348 $ 12348
Using a simple label would more likely provide
56 $ 56
12348 $ 12348
B
Brendan Reynolds
When you copy an MDB from one PC to another PC with different regional
settings, fields and controls with a Currency format retain the format used
on the PC where they were created. There's a Microsoft Knowledge Base
article that explains why this was done. Suppose you were sending an MDB
containing financial data to a colleague in another country. If the currency
fields automatically adopted the format used on your colleague's PC, one
Euro would become one Dollar (for example) resulting in incorrect data.
If you want to automatically use the currency format of the PC on which the
app is running, you can set the format of controls that display currency at
run-time instead of at design time. In the Form_Open and Report_Open event
procedures of forms and reports add code like the following ...
Me!SomeControl.Format = "Currency"
Alternatively, if you downloaded your template from the US template site,
have you checked whether there is a version of that template at the UK site?
http://office.microsoft.com/en-gb/templates/CT011359381033.aspx
settings, fields and controls with a Currency format retain the format used
on the PC where they were created. There's a Microsoft Knowledge Base
article that explains why this was done. Suppose you were sending an MDB
containing financial data to a colleague in another country. If the currency
fields automatically adopted the format used on your colleague's PC, one
Euro would become one Dollar (for example) resulting in incorrect data.
If you want to automatically use the currency format of the PC on which the
app is running, you can set the format of controls that display currency at
run-time instead of at design time. In the Form_Open and Report_Open event
procedures of forms and reports add code like the following ...
Me!SomeControl.Format = "Currency"
Alternatively, if you downloaded your template from the US template site,
have you checked whether there is a version of that template at the UK site?
http://office.microsoft.com/en-gb/templates/CT011359381033.aspx
J
Jamie Collins
Brendan said:When you copy an MDB from one PC to another PC with different regional
settings, fields and controls with a Currency format retain the format used
on the PC where they were created. There's a Microsoft Knowledge Base
article that explains why this was done. Suppose you were sending an MDB
containing financial data to a colleague in another country. If the currency
fields automatically adopted the format used on your colleague's PC, one
Euro would become one Dollar (for example) resulting in incorrect data.
Forget the front end controls and formatting: the currency of the data
in the column should be explicit, either through metadata (e.g. column
named 'total_budget_euros_amount') or in the data itself (e.g. columns
for 'total_budget_amount' and 'total_budget_currency_code'
respectively).
This is one issue among others (portability, rounding rules, etc) that
make the CURRENCY type worth avoiding.
Jamie.
--