Comma used as decimal causing issues with parameter list

[Callan]

The program is using the regional settings for Brazil. Using these regional
setting. the currency is as such: R $ 100,00.
they use a comma instead of a full stop to denote decimals.
This now causes an issue when sent as a parameter value as Access does not
see it as a "whole" parameter, but instead sees the comma as a list seperator.

Therefore all functions using currency are failing due to there being "too
many" parameters.

Please, any help on the matter would be greatly appreciated

Thanks in advance.

 

[Alex Dybenko]

Hi,
for currencies you have to change decimals to dot before assigning to
parameter, this should work. you can use replace function

Also you can declare parameter and assign it a currency variable type

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Callan]

Hi Alex,

Thanks, but I've had to write a seperate function to programmatically change
the comma in the parameter to a decimal.

It doesn't help if you change the decimal to a dot. The regional settings
overide the change and keep it as a comma. This is the same when declaring
the variable as currency. even if you change the decimal point in "Regional
Settings" in windows.

If anyone else has a better way of solving this other than the way I have
done it, this would be great to know.

Thanks again.

 

[Alex Dybenko]

Well, what I mean is the following - say you have to run a query and pass
currency variable to it - then I do the following:

strSQL= "Update MyTable Set Price=" & replace(curPrice & "",",",".")

this will result:
strSQL= "Update MyTable Set Price=123.44"

and perfectly understandable by jet. in Russia we also have comma as decimal

perhaps you can post your code here, so we have better idea of what you are
doing

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com