Left and Right Functions - Vista

[T@discussions.microsoft.com Alvin T]

I have an MS-Access app being used by 15 people on laptops in the field.
Most are on 2007 and Windows XP and are experiencing no problems. Two users
are using Vista and are getting error messages (Function is not available in
query expressions) whenever the code hits a simple Right("str",int) or
Left("str",int) function. It only occurs on those users on Vista. There are
NO missing references when I check for them. Any ideas for a fix or
workaround?

[Tony Toews [MVP]]

There may not be missing references but these are still the symptoms
of a reference problem. Please run the following code and report
back your references so we can give you some suggestions.

Sub ViewReferenceDetails()

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " - " & ref.Major & "." & ref.Minor & "
- " & ref.FullPath
Next ref

End Sub

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/