"InStrRev Function is not Defined" Error in Access 2000

[Raspberry69]

Hello everyone,

I imported a report from another computer ( both have Access 2000 installed).

Although it works fine on the other machine, I get the following error on on this machine.

"InStrRev Function is not Defined" I tried to reinstall Access, it did not help.

Any suggestions on what I can do to fix this problem are appreciated.

Thank you



Here is the SQL for this report:

SELECT Orders.OrderNumber, Orders.SourceOrderNumber, Orders.FinalProductTotal, Orders.Comments, Orders.OrderSource, Orders.LocalSortText1, a.DateShipped, Orders.LocalSortText2, Orders.Email, Tracking.TrackingID, Tracking.EmailSent, a.Adjustment, a.DetailDate, IIf(Len(Orders.ShipName) Is Null,"",Right(Orders.ShipName,Len(Orders.ShipName)-InStrRev(Orders.ShipName," "))) AS LastName, IIf(Len(Orders.ShipName) Is Null,"",Left(Orders.ShipName,InStrRev(Orders.ShipName," "))) AS FirstName, Orders.OrderDate FROM (Orders INNER JOIN [Order Details] a ON Orders.OrderNumber = a.OrderNumber) LEFT JOIN Tracking ON Orders.OrderNumber = CLng(Tracking.OrderNum) WHERE a.ItemNumber = 1 AND Orders.Cancelled=False;

 

[easyit]

Hi,


This can happen if references to libraries are broken (or have been broken). Even the most basic Access functions give errors then.

U could solve this by either:
Re-Enabling the broken reference or by
Disabling a reference, closing the popup window, reopening it and checking the reference again.

U find the refrences in the VBA window (ALT+F11), in the menu options>>references



EasyIT

"Do you think that’s air you're breathing?

 

[Raspberry69]

Thank you for the reply, easyit.

I will try to follow your recommendations, although I am not sure I know how to re-enable a broken reference.

Raspberry69

 

[easyit]

..it's easy, there are checkboxes. just remeber the name of teh reference you are uncheking.

EasyIT

"Do you think that’s air you're breathing?