Missing Reference Problem (I think)

[krispi]

Hello – sorry to re-post this problem but it’s driving me mad!

I have a search function which builds an SQL statement in VBA using AddToWhere. This is something I have used a lot of times (I think the original code came from some kind member of this forum!) Suddenly, Access refuses to recognise AddToWhere, saying the Sub or Function is not defined.

I haven’t done any developing for a while and the PC I am using is different to the one I used when I built my other databases. If I go into Tools/References when in the module, Visual Basic For Applications is ticked, however the VBA332 file is not in the location shown in the filepath. Is this likely to be the cause of my problems? And if so, will downloading the VBA332 file into the correct location be the solution?

Any help, as always, is gratefully appreciated.

Chris

 

[Trendsetter]

You can either move the function to the location shown in the list or untick the entry as it exists and browse for the new location to enter into the list - this usually happens with Windows version that have \system32

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk