If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
EUROCONVERT Trouble
I have tried to use the EUROCONVERT Function to convert £ to Euro's but it
keeps coming up with "Subscript out of range". How do I correct this problem? I am putting it in a Label DblClick procedure to convert the amount in a Text Box. I am using a Varient Variable, which has the value of the Text Box, as the number argument. The source currency is GBP and the target currency is EUR. It is written as EuroConvert(variable name, "GBP", "EUR") as shown in the Microsoft Help. Do I need to ad anyting else to it? |
#2
|
|||
|
|||
Hi Jim,
EuroConvert() only converts the former national currencies of the euro zone, using the EU's official fixed exchange rates. AIUI the idea was to simplify conversions during the transitional period and historical comparisons thereafter. So it doesn't recognise "GBP". Presumably the function will be updated if and when other member states commit to fixed exchange rates and the euro. To convert between GBP and EUR you'll need to provide an appropriate exchange rate yourself (current or for the date in question). I'm sure there are web services that offer this but have no experience of using them; for manual look-ups of exchange rates I usually use www.oanda.com. On Fri, 8 Apr 2005 14:09:03 -0700, pompeyjim wrote: I have tried to use the EUROCONVERT Function to convert £ to Euro's but it keeps coming up with "Subscript out of range". How do I correct this problem? I am putting it in a Label DblClick procedure to convert the amount in a Text Box. I am using a Varient Variable, which has the value of the Text Box, as the number argument. The source currency is GBP and the target currency is EUR. It is written as EuroConvert(variable name, "GBP", "EUR") as shown in the Microsoft Help. Do I need to ad anyting else to it? -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
#3
|
|||
|
|||
"pompeyjim" wrote: Thanks John. Looks like I'll have to stick to manually doing it (or at least my client will). |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Video trouble after installing RealPlayer | davids | Powerpoint | 2 | November 30th, 2004 01:18 AM |
Trouble Displaying a Non-Contiguous Data Range | David | Charts and Charting | 2 | June 8th, 2004 02:56 AM |
trouble typing 2-pg letters with Word 03 | Wendy | Formatting Long Documents | 1 | May 7th, 2004 04:34 PM |