The Instr function in VBA checks to see if a string is contained within another string. This can be useful when trying to extract information from strings of data contained in Excel cells, for example. Instr Syntax The Instr function is made up of 4
Using the ByVal argument in VBA is a way to pass values to a function in VBA while retaining the original value of the variable. For example, you may have a list of names and dates of birth in your Excel sheet, and you wish
By Joseph Maabo New developers are usually faced with the “operation must use an updateable" query error when trying to update records in a database through a local or a web (online) application. Possible reasons for the occurrence of the error There are several reasons
In this article, we will talk about the Data Type Mismatch errors in MS Access. The “Type mismatch in expression” error indicates that Access cannot match an input value to the data type it expects for the value. For example, if you give Access a
In this article, we will see how to update records in Access database through Excel VBA using ActiveX Data Objects (ADO). Let’s say you have a database named “Products". In that database, there is a table “ProductTable" that contains the product details of your business
The Range.Select method is used by VBA Macro developers for various purposes. These can be as simple as selecting a cell on an active worksheet, selecting one on another worksheet, or selecting a range of cells on a worksheet from a different workbook. Sample code #
The Range.copy method is simply used to copy a range into a specified range or the clipboard. This is commonly used when you have specific data range within the worksheet that you want to copy. It can also be used to copy a formula from
This property can be used to select a Range. It returns a Range object that represents the cells. It refers to the cells of the specified range object, which can be a worksheet or a range of cells. It requires two parameter values “RowIndex” and
This article explains how you can use VBA for Access to open google earth. Note: The google earth API will only be available if you have Google Earth installed on your computer. The first step would be to add reference to the Google Earth 1.0 Type Library. Note the
Previously in the article Open Form When Database is Opened, Access I’ve explained how you can use an “Autoexec” macro to open a certain form every time the access file is opened. In this article another method will be explained. – Step 1: Click on the File button: –
