Multiple currency working

  • Thread starter Thread starter Jim McDonald
  • Start date Start date
J

Jim McDonald

Hi all
Can anyopne help? I have a system with lots of VBA coding, and I want to be
able to switch working currency from Sterling to US Dollar and back. How do
I do this? Any ideas gratefully received !!
Thanks
Jimbo
 
converting all the data back n forth isn't do-able - maybe currency
convertor on screen - txtDollar?

air code:

sub txtSterling_Got Focus
txtdollar = txt Sterling *.734 (whatever the xchange rate is - maybe
even have this in seperate text box)
end sub
 
Hi Jim,

Can you explain in a bit more detail just what you need to do?
Presumably it's more than just changing the currency symbols and label
captions.

For example, do you want to be able to store (say) prices
indiscriminately in GBP and USD? That's simple: accompany each price
field with a Currency field. Do you need to store all prices in both
currencies? Do you have a table with the various daily exchange rates?
 
Thanks for that. I ended up hardcoding it. Jim
JethroUK© said:
converting all the data back n forth isn't do-able - maybe currency
convertor on screen - txtDollar?

air code:

sub txtSterling_Got Focus
txtdollar = txt Sterling *.734 (whatever the xchange rate is - maybe
even have this in seperate text box)
end sub
Click to expand...
 
Thanks John. This is sort of what I did in the end. Keep prices in GBP but
re-calc for invoices and output to print with currency symbol. Rates entered
daily.
thanks again
jim
 
Back
Top