Reply to thread

Message: [QUOTE="Allen Browne, post: 1026148"] You may be able to work around the immediate issue if you open tblPlayers in design view, and remove any expression referring to Date from its properties (e.g. the field's Default Value.) Similarly, remove the expression from any properties of the text box on the form, and possibly code of the form or controls. But if you had the same problem with Format() as well, then it *is* a problem with references. Jot down the names of all the references you are using, as well as the full path to the file. It's hard to read this as the window is generally to small to display it, but you can open the Immediate Window (Ctrl+G) and enter: ? References("ADO").FullPath to see the full path to each reference. Then: 1. Uncheck all references except Access and VBA (which you can't uncheck.) 2. Close the database. 3. Unregister each library, and re-register it. Details in the article already linked: [URL]http://allenbrowne.com/ser-38.html[/URL] 4. Open the database again, and select those same references again, or at least the ones you really must have to get the code to compile. If it's still broken at this stage, there is another issue here. It could be a damaged library (particularly after a viral infection), or it could be a corrupt database (the kind of thing a decompile might fix.) [/QUOTE]