Sudden 'compile error. in query expression'
Please forgive me if this has been answered elsewhere, but I can't seem to find the thread that covers it:
I have a fairly simple db that has been working perfectly for the last 7-8 months, but now I'm getting variations of the following error messages for all but one of my queries:
Compile error. in query expression '(Format([VisitorInfo.Interview], "dddd"))+" at "+(Format([VisitorInfo.Interview], "h:nn am/pm"))+" - "+([VisitorInfo.Interviewer])'.
Compile error. in query expression '(DatePart("ww", [VisitorInfo].[TutorInt]))=(DatePart("ww", Now())+1)'.
There were no changes made to any of the queries, or any code. The only change was the installation of new db software, which I have heard it suggested can sometimes cause reference problems. There are no missing references listed, however, and simply unchecking and rechecking available references did not seem to help, so my minimal knowledge of how to deal with possible reference problems is exhausted.
Any thoughts on this would be greatly appreciated. Thanks.
Specialization is for insects. -Robert Heinlein