Forum Discussion

Gertdj's avatar
Gertdj
Copper Contributor
Feb 21, 2020
Solved

Ms Access different results from same query on different pc's

I have developed an Access 2016 application with an insert query from VBA. This insert query is reliant on a select query for input.  The functionality works correctly on my pc, but the select quer...
access
office 365
  • Gustav_Brock's avatar
    Gustav_Brock
    Feb 26, 2020

    Gertdj And where are the positioned? It could be decimals normally having a dot, now a comma as the decimal separator. Always convert decimals to text with Str:

    TextValue = Str(DecimalValue)

     

Gustav_Brock's avatar
Gustav_Brock
Iron Contributor
Feb 26, 2020

Gertdj And where are the positioned? It could be decimals normally having a dot, now a comma as the decimal separator. Always convert decimals to text with Str:

TextValue = Str(DecimalValue)

 

Gertdj's avatar
Gertdj
Copper Contributor
Feb 28, 2020

Gustav_Brock  - I have checked the system settings on the PC that was misbehaving and found that the decimal separator was indeed set to a comma. After changing this to dot all is working as expected!
Thank you for the excellent advise!

Resources