Problem with Decimal separator

[radek225]

I have problem in DAO.Recordset when I want to take value with decimal numbers because In my region we have "," instead "." so Ms Access shows an error "comma in your sentence..." I need take a value eg. 12313,4345 (sna). I tried Replace function but it doesn't work:/ I don't want to round my value:/. What should I do?

if recIn!id_rozklad = DLookup("Id_Rozklad", "tblRozklad", DMin("sna", "tblRozklad")) then ...

 

[pr2-eugin]

Your DLookup is wrong for a start. Next the words "does not work", does not make any sense. Explain what is the error, error description.

 

[PeterF]

The Where part of your Dlookup is not complete, the field name is missing.
I think it should be:

DLookup("Id_Rozklad", "tblRozklad", [COLOR="Red"]"sna = " &[/COLOR]  DMin("sna", "tblRozklad"))

 

[radek225]

Your DLookup is wrong for a start. Next the words "does not work", does not make any sense. Explain what is the error, error description.

Run-time error '3075'
syntax error (comma) in a query '4,6666666666'

It's not exactly the same message because I don't have english language pack.

The Where part of your Dlookup is not complete, the field name is missing.
I think it should be:

DLookup("Id_Rozklad", "tblRozklad", [COLOR="Red"]"sna = " &[/COLOR]  DMin("sna", "tblRozklad"))

The same error in both situation:

DLookup("Id_Rozklad", "tblRozklad", DMin("sna", "tblRozklad"))

and

DLookup("Id_Rozklad", "tblRozklad", "sna = " &  DMin("sna", "tblRozklad"))

Recordset can't understand

4[COLOR="Red"],[/COLOR]6666666666

but I can't change decimal point in Ms Access without changing all regional settings:/. In my region "," is correctly so In tables and forms Ms Access also shows "," like a decimal point, but when I want to use value in Recordset then Ms Access shows an error:/ which I mentioned at the beginning

 

[Minty]

Even with the language differences, I've never seen an access error that specified a 'comma' was missing.
The nearest you normally get would be a missing operand. I think you may be making the assumption it's the comma but that it isn't.

Are you absolutely sure sna is a numeric field?

 

[radek225]

Even with the language differences, I've never seen an access error that specified a 'comma' was missing.
The nearest you normally get would be a missing operand. I think you may be making the assumption it's the comma but that it isn't.

Are you absolutely sure sna is a numeric field?

It's not about language differences it's about region differences. Yes it's numeric field as double.

 

[Galaxiom]

In regions with comma as the decimal separator, functions often use the semicolon as the argument separator.

 

[JANR]

You can wrap your DMin Expression using the Str() function.

DLookup("Id_Rozklad", "tblRozklad", "sna = " & [COLOR="Red"] Str[/COLOR](DMin("sna", "tblRozklad"))[COLOR="red"])[/COLOR]

works ok in my test

JR