How to Fix Microsoft Access VBA Error 424 on a DAO Execute Statement
Question details
User needs to resolve Microsoft Access VBA error 424 that occurs when a DAO Database.Execute statement updates a date field, even though the table and field exist and other update statements succeed.

- Product
- Microsoft Access (VBA and DAO)
- Device & OS
- not provided
- Scenario
- Running a VBA procedure that uses DAO to execute an UPDATE statement against an Access table, specifically updating the STATUSDATE date field.
- Observed behavior
- VBA raises error 424 'Object required' at the DAO.Execute line when the SQL string contains a table-field reference such as [tblBulkStatusUpdate]![STATUSDATE] instead of a valid VBA value expression.
Open the Access database and press Alt+F11 to open the VBA editor. Locate the DAO.Execute statement that updates the date field and verify how the SQL string is constructed before changing any code.
Replace invalid table-field references with valid VBA date expressions
Use this when the DAO.Execute SQL contains [TableName]![FieldName] and Microsoft Access raises error 424 during a date update.
The DAO.Execute method expects a complete SQL string. In VBA, a table-field reference such as [tblBulkStatusUpdate]![STATUSDATE] is not a valid value expression outside a query, form, or recordset context.
Construct the date value separately with VBA functions such as DateSerial and TimeSerial, or read it from an Access form control with Forms!FormName!ControlName.
In Microsoft Access, press Alt+F11, open the module containing the DAO.Execute statement, and find the line that updates the date field.
Change [tblBulkStatusUpdate]![STATUSDATE] to Forms!YourFormName!YourDateControl if the value comes from a form, or assign the date to a VBA variable before building the SQL string.
Concatenate the date value into the SQL using # delimiters, for example: "UPDATE tblBulkStatusUpdate SET STATUSDATE = #" & Format(dtStatusDate, "mm/dd/yyyy hh:nn:ss") & "# WHERE ..."
Click Debug > Compile VBAProject in the VBA editor, fix any remaining syntax issues, then run the code and confirm that error 424 no longer appears.

Use a saved parameter query and execute it with DAO QueryDef
Use this to reduce SQL concatenation errors by storing the update as an Access parameter query and supplying the date value through QueryDef parameters.
Use WPS Office as a Free Alternative for Everyday Office Tasks
WPS Office does not include Microsoft Access or its VBA environment, so it cannot directly fix Access DAO error 424. However, it is a free, lightweight, easy-to-use Office alternative with strong compatibility for Word, Excel, and PowerPoint files, a familiar ribbon interface, and seamless migration for everyday document and spreadsheet work.
- 1. Download WPS Office: Go to the WPS Office download page and click the Download WPS Office Free button for Windows, macOS, Linux, iOS, or Android.
- 2. Open existing Microsoft Office files: Launch WPS Office and use File > Open to open .docx, .xlsx, and .pptx files without converting them.
- 3. Use the familiar ribbon interface: Use the Home, Insert, and View tabs in WPS Writer, Spreadsheet, and Presentation to continue everyday office work.

Frequently Asked Questions
What causes Microsoft Access VBA error 424 on a DAO.Execute statement?
It usually means VBA is treating an expression as an object reference when it is not. In a DAO.Execute SQL string, a table-field reference such as [tblBulkStatusUpdate]![STATUSDATE] is not a valid VBA value expression and triggers 'Object required'.
Can I use [tblBulkStatusUpdate]![STATUSDATE] directly in a VBA SQL string?
No. That syntax works in Access query design or certain contexts, but in a VBA string for DAO.Execute it is not evaluated as a field value. Use Forms!FormName!ControlName, a VBA variable, or a recordset field instead.
How should dates be formatted in Access VBA DAO SQL?
Concatenate date values as strings enclosed in # delimiters, such as "#03/15/2025 08:00:00#". You can build the value with DateSerial and TimeSerial and wrap it with Format(..., "mm/dd/yyyy hh:nn:ss").
Does WPS Office support Microsoft Access .mdb or .accdb databases and VBA?
No. WPS Office is not a database replacement and does not provide a Microsoft Access VBA environment. It focuses on documents, spreadsheets, and presentations with Microsoft Office format compatibility.
How can I avoid concatenation errors in Access VBA update queries?
Store the SQL in a saved Access query with parameters, then execute it from VBA with a QueryDef and assign parameter values through qd.Parameters. This avoids manually building date literals.




