Forum Discussion

Gertdj's avatar
Gertdj
Copper Contributor
Feb 21, 2020

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)

     

Gertdj's avatar
Gertdj
Copper Contributor

To more correctly state the issue...

The functionality works correctly on my Dev PC, but the issue occurs when running the program on another PC, i.e. generates additional output fields. 

M_A_M_A's avatar
M_A_M_A
Copper Contributor
Feb 23, 2020
Misma versión de aplicación y sistemas?
  • Gertdj's avatar
    Gertdj
    Copper Contributor
    Feb 26, 2020

    Yes, Windows 10, Office 365 

Resources