Hello all i am in a bit of a jam i had an Access database which i have updated to SQL Server 2000 and Office XP the situation is that i had queries that had reference to a function located module in the database's now it seems that it dosent accept these functions although thet have been converted properly it also dosent accept "IIF", "=Trim([FirstName] & " " & [LastName])" and some others i need as much information as possible im just starting this out but it dosent look promising can anyone help me?

My guess is that Microsoft has still not fixed the broken reference problem. Try opening any code module, then select Tools/References from the menu and look for the word "MISSING". Uncheck the reference and try your function again. Usually just unchecking the reference will force Access to relocate it. If it still cannot be found, you'll have to find it manually or perhaps register some activeX control that was not properly installed. Anyway, there are lots of postings on this topic. So search the archives for more help.

thank you but i dont have "MISSING" under tool/refrences in Access while in design mode of a module

[This message has been edited by Squalor (edited 10-02-2001).]