I am trying out the SEARCH() function in the immediate window of Access but it gives me a compile error
stating Sub or Function not defined.


When I use the MID() function in the immediate window it gives me the proper result.


Could I be missing some references ? Do I have to reload access to have this SEARCH() function work ?


Any help on this will be greatly appreciated.


Thanks,


Chris
Get Your Private, Free E-mail from Indiatimes at  http://email.indiatimes.com
Buy the best in Movies at http://www.videos.indiatimes.com
Now bid just 7 Days in Advance and get Huge Discounts on Indian Airlines Flights. So log on to  http://indianairlines.indiatimes.com
and Bid Now !