Compiler error on a non-existent line

[JoeS01]

I have installed my fully operational Access 2010 data base from another computer. When I run it on my work laptop I get a "Compiler error. in Query Expression Round(Val(func..... ' etc.

The trouble is, this formula does not exist anywhere in my VBA code. I have used Ctrl F and selected the whole project in which to do the search.

I am using windows 7 Professional with 64 bit OS, and with VBA 7.0 on my work laptop.

Can anyone please suggest where the problem might be?

 

[JoeS01]

Thanks Bob, will give this a go

 

[JoeS01]

Problem solved!! Switched my work MS Office to 32 bit, and software developed on my home 32 bit Office ran perfectly on the work laptop. Many thanks for pointing this out, Derek

 

[Derek Brown]

Thank you for the feed-back - it is good to know that your problem has been solved and that this post may later help others.