Forum Discussion
Gertdj
Feb 21, 2020Copper Contributor
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...
- 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
Feb 26, 2020Copper Contributor
Gustav_Brock Thank you - I will try that, but want to state again that the code works perfectly on two pc's and is only producing extra output fields on the third...
Gustav_Brock
Feb 26, 2020Iron Contributor
Gertdj And which are those additional fields?
- GertdjFeb 26, 2020Copper Contributor
Gustav_Brock - Expr1 and Expr2 - both with a value of 48 that is not anywhere in my dataset
- Gustav_BrockFeb 26, 2020Iron Contributor
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)
- GertdjFeb 28, 2020Copper Contributor
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!