Showing posts from August, 2009

Word, "This file contains macros with an expired..."

I started getting this error message when I opened Word, "This file contains macros with an expired or revoked signature." In my case, this was due to a Global Template Add-in that had an expired certificate. Word behaves differently depending on the Macro Security level. Very High : You only get a message that macros are disable for this project. High : You get an initial error message of "This file contains macros with an expired or revoked signature," before the prompt of macros being disabled. Medium: You get the option to Disable or Enable the specific macro. This dialog box will also provide some clues as to the source of the problem. Low : No warning or disabling of any macros. To change the Macro Security, go to Tools >> Macro >> Security... With an expired Certificate, if you still want to use the macro or template, you either need to set the Macro Security to Medium or Low. A Low setting can open you up for other problems, while Medium require

MS Access -- Run-time error '3464'

Being that I don't use MS Access often, I always look for examples of my prior work to assist me with my new problem. Today I ran into this error, Run-time error '3464': Data type mismatch in criteria expression , which was a good reminder. When writing a VBA query, Text needs wrapping in quotes, Dates need wrapping in hashes, and numbers need neither of these. If you get it wrong, you'll get the 3464 error message.