Category Archives: Error

Data type mismatch in criteria error box

ByRef Argument Type Mismatch Error: Fixes

In this article, we will look at the ByRef argument type mismatch error.  First, let us have a look at what is ByRef and the difference between ByRef and ByVal. In Visual Basic, you can pass an argument to a procedure or function by value or

No Thumbnail

Word VBA OverFlow Error When Multiplying/Adding Integers

It might have occurred to you when working with integers in VBA for Word that you get  the following error: This error generally occurs when  you are doing arithmetic operations on integer values that result in: Values larger than 32767 Values smaller than -32768 This is because integers only

No Thumbnail

Word Automation VBA, Common Errors

In the article below I’ve explained how you can automate a word document from another application using VBA: VBA, Automating Word From Excel Though the automation process itself is quite straight forward, there are many things you will need to keep in mind. Consider the code below: ActiveDocument.Tables.Add

No Thumbnail

#Name? Error Referencing Fields Access Forms, Expression Builder

This article explains the reason why you might encounter the “#Name?” text when trying to reference a Field in one of the textboxes in an Access Form using the Expression Builder: – Reason #1: Attempting to reference the field using its full name will result in this error:

No Thumbnail

Excel VBA Strings: Common Errors When Using Strings

In this article I will explain some of the most common errors people encounter while working with strings. For more information regarding string commands please visit VBA Excel String Processing and Manipulation. You can download the codes and files related to this article here. Jump To: