Comma used as decimal causing issues with parameter list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
Back
Top