Jun 6, 2024 · This article applies to either a Microsoft Access database (.mdb) file or to a Microsoft Access database (.accdb) file. Symptoms. Consider the following scenario. You have a procedure that contains a Microsoft Visual Basic for Applications (VBA) function.

Jul 11, 2018 · Access database not opening in Access 2016. Used to work in Access 2007. Now receiving "There was an error compiling this function. The Visual Basic module contains a syntax error. Check the code, and then recompile it."

Mar 4, 2003 · Check for a missing reference. 1. Does it compile clean? 2. Have you tried stepping through the code to find the offending syntax? 3. What happens if you leave the x switch off the command line? 4. (repeat) How are the ref's? You must log in or register to reply here.

Mar 3, 2020 · I am trying to open an application that works with Access and I keep receiving an error code that says: There was an error compiling this function. The visual basic module contains a syntax error. Check the code, and then recompile it.

Aug 25, 2021 · I'm trying to create a log table in MS Access to track changes to the date field in a table. Every time I try to change a field value in the form, I get a syntax error message saying: "Syntax error (missing operator) in query expression."

Sep 24, 2019 · You can't have a syntax error if there is no code. I would open the VBE (press Ctrl+G) ad then open the Debug menu and press Compile to find all syntax errors. I would also try a Compact and Repair.

May 10, 2023 · This error occurs because your Access database includes code that is incompatible with 64-bit systems. To fix it, you'll need to update your code to work with 64-bit systems. Here are the steps you can take to fix this error: Open your Access database and go to the Visual Basic Editor. In the VBE, go to the Debug menu and select Compile.

Jan 11, 2018 · These two laptops are running Windows 10 and when we try to open the database they get a 7960 error and an error saying there was an error compiling this function. The visual basic contains a syntax error.

Jul 18, 2022 · The visual basic code you entered contains a syntax error or the Output procedures are not available. Make sure there isn't a syntax error in your code. if the syntax is correct, run Setup to reinstall Microsoft Access.

Jan 24, 2013 · "The visual Basic module contains a syntax error" for a simple Left function? So we have an access 2010 database. The Zip code field has a mixture of 5 digit codes and 9 digit codes -- we want to pull just the first five digits.