MS Access 2000 - Undefined function 'replace' in expression

[Guest]

I am having problems running the "replace" function from a query in MS-Access
2000. This works for one workstation and doesn't work on another
workstation. We re-installed MS-Access 2000 on the workstation that is
having the problem. I did researched the issue in this website and read the
solution that was posted. However, this did not work. Does anyone know of
another solution.

Thanks,

Here is the solution founded on another message.
-----------------------------------------------------------------------------------------
The Replace function did not work in queries in the early version of ACCESS
2000. Get and install the latest updates for ACCESS 2000 and Jet to fix this
problem.

See these Microsoft.com links:

http://support.microsoft.com/default.aspx?scid=kb;en-us;239114
http://office.microsoft.com/en-us/officeupdate/CD010226001033.aspx
----------------------------------------------------------------------------------------

 

[fredg]

I am having problems running the "replace" function from a query in MS-Access
2000. This works for one workstation and doesn't work on another
workstation. We re-installed MS-Access 2000 on the workstation that is
having the problem. I did researched the issue in this website and read the
solution that was posted. However, this did not work. Does anyone know of
another solution.

Thanks,

Here is the solution founded on another message.
-----------------------------------------------------------------------------------------
The Replace function did not work in queries in the early version of ACCESS
2000. Get and install the latest updates for ACCESS 2000 and Jet to fix this
problem.

See these Microsoft.com links:

http://support.microsoft.com/default.aspx?scid=kb;en-us;239114
http://office.microsoft.com/en-us/officeupdate/CD010226001033.aspx
----------------------------------------------------------------------------------------

You can use the Replace function in A2000 by first creating a wrapper
function, then calling that function from the query.

Create a new module:
Function ReplaceText(StringIn as String) as String
Dim NewString as String
NewString = Replace(StringIn,"xyz","abc")
ReplaceText = NewString
End function
=======

Call it from the query:
ChangedText:ReplaceText([FieldName])