Tag Archives: Error

On Error…Go To: Error Handling in VBA

Even when your code is perfectly constructed, the user might not always do what you would expect.  For this reason, you need to insert error handlers into your code whenever there might be a reason that an error might occur. Handling an error when incorrect

VBA Error 400: What Are the Causes and How to Fix It?

Introduction It is often said that debugging is part of programming, and through error messages, the programmer can easily identify where there are problems in his/her code. But as you can see from the above screenshot the VBA Error 400 is one of those annoying

No Thumbnail

Query Dates Type Mismatch Error, Access

Previously in the article Query Dates, Access I’ve explained how you can run queries on date values.  However if double quotes are used in the  criterion section a type mismatch error will occur. In the figure below you can see a query in design mode: This is the