« Previous Thread | Next Thread » Thread Tools Show Printable Version Email this

Select Tools | References... The Visual Basic Module Contains A Syntax Error Alternatively, try something like this: IIf([last call time] Is Null, Date(), DateValue([last call time]) For anyone who wants to know why I didn't suggest NZ(), see: http://allenbrowne.com/QueryPerfIssue.html#Nz -- Allen Browne - No problem, I was in the same place when I was looking for it.

Thanks for the reply to your own post.

Reply With Quote 04-29-2016,08:34 PM #2 Standtruec View Profile View Forum Posts Novice Windows 10 Access 2010 64bit Join Date Apr 2016 Location New Zealand Posts 2 Solved I fixed my In my code I would like to get the item selected. Yes, my password is: Forgot your password? Compile Error Can't Find Project Or Library Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud

Microsoft Office for Developers > Access for Developers Question 0 Sign in to vote Error window pop-up with this error 'compile error. Soooooo I am totally confused now. Solved Compile Error in query expression in ACCESS 2010 Posted on 2012-09-06 MS Access MS Office 1 Verified Solution 9 Comments 1,345 Views Last Modified: 2012-09-06 Hi, I have an user http://performancepccanada.com/compile-error/compile-error-in-hidden.php Thanks!

Thanks, but I can't take credit for the fix, I only found it somewhere else.