Swedish Versions of Code Access 97/2003

[Brian1960]

I have an application with some queries which have syntax like the following examples

Left(fieldname,3)
AND
Right(fieldname,3)
AND
UCase(fieldname)
AND
Mid(fieldname),4,3)

The code works perfectly here but when translated to the swedish version it does not like the functions.
Does anyone know a way around this?

 

[WayneRyan]

Brian,

Generally, when functions like Mid, Right, Left, etc. are not recognized it is a
reference problem. Get any code in Design view and select:

Tools --> References

Compare the two machines. There should be differences.

Use the Search Facility here and look for "References". It is a common
problem.

Wayne

 

[Brian1960]

Thanks,
There were no differences but apparently there is a known issue. Just tick another reference close the Db, open and then un-tick the new reference. It works fine after that.
Bizzare but fixed.