Excel Indirect Function to convert text to Reference

Posted on March 25, 2015March 25, 2015 by Wyman W

This tutorial explains how to use Excel Indirect Function to convert text to Reference, and how to use in Data Validation. Excel Indirect Function Excel Indirect Function is to convert text to Reference (or cell value). For example, formula =A1 returns A1 value because A1 is considered as Reference, but ="A1" is considered as Text. Excel Indirect Function can convert the "A1" Text to become Reference. One popular use of Excel Indirect Function is to use in Data Validation where you convert ...

Excel Address Function to convert column number to letter

Posted on March 24, 2015April 2, 2015 by Wyman W

This Excel tutorial explains how to use Excel Address Function and how to convert column number to column letter. Excel Address Function Excel Address Function is used to combine column number and row number to return Cell address in Text format. Excel Address Function is most useful is converting column number to column letter, or use with Indirect Function to convert the Text address to Range Object. Syntax of Excel Address Function ADDRESS( row, column, [abs_num], [a1], [sheet_text] )...

Access link to external ODBC data source

Posted on March 24, 2015March 26, 2015 by Wyman W

This tutorial shows how to link Access to external ODBC data source. Access link to external ODBC data source ODBC (Open Database Connectivity) is a standard programming language middleware API for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. The reason for connecting Access to ODBC is that Access can directly get database data once the connection is setup, saving a lot of time to make Query thro...

Access Report – hide Subreport if no data

Posted on March 24, 2015June 26, 2015 by Wyman W

This Access tutorial explains how to hide Subreport if no data. You may also want to read: Access Report reset total page number and insert blank page Access Report page break by Group and add blank page Hide Access Subreport if no data Assume that you have a Master Report called Report A, the figures are displayed in Group Header. Now you have a Subreport called B and you want to display data for each Group Header. Drag Report B to A and define the joined Fields. As you...

Access Record Source Control Source Row Source Difference

Posted on March 23, 2015December 15, 2016 by Wyman W

This tutorial explains difference among Record Source, Control Source, Row Source in Access Report and Form. Difference among Record Source, Control Source, Row Source In Access Report and Form, there are three different data sources, which can be very confusing for starter. Record Source Record Source is a Property of Report and Form, it is the data source that you want to appear in Report and Form. Record Source can be SQL statement, Table, Query. Record Source can have more than one F...

Auto Run Access Form using AutoExec

Posted on March 23, 2015 by Wyman W

This tutorial explains how to auto run Access Form using AutoExec Macro. Auto Run Access Form Access can auto run any Objects, while Access Form is the most popular Object to auto run, this tutorial will cover mainly auto run Form. AutoExec is a reserved name for Macro, indicating that this Macro will run when Access is opened, we can make use of it to auto run any Procedure in Access. You may also want to consider Windows Task Scheduler to auto open an Access and then execute Procedure ...

Access Form Combo Box and save selected value

Posted on March 23, 2015April 4, 2015 by Wyman W

This tutorial explains how to use Combo Box in Access Form and save selected value for use in another Form or Report. You may also want to read: Access Combo Box value depends on another Combo Box Access Form Combo Box Combo Box is also known as Dropdown Box, which allows users to select data from a list by clicking on the down arrow button. The advantage of Combo Box is that you can have control over what users will input, this will prevent unexpected input and typo. Because Comb...

Access Form remove last blank row using AllowAdditions Property

Posted on March 21, 2015March 21, 2015 by Wyman W

This tutorial explain how to remove last blank row in Access Form using AllowAdditions Property. Access Form remove last blank row This is a very quick and short tutorial showing how to remove last blank row in Access Form. When you create a Access Form, by default, it shows the last record as blank as below, because the blank row is for you to add new record. To remove the blank row, simply not allow the Form to add any record. Navigate to Form Property > Data > Allow Addit...

Access Form mask Password Text Box

Posted on March 21, 2015March 6, 2017 by Wyman W

This Access tutorial explains how to mask text in Password Text Box and ComboBox Control with asterisk in Access Form. You may also want to read: Access user login Form and verify password Access Form Password Text Box When you design a Access Form which requires users to input confidential information, such as log in password, you may want to mask the password with asterisk. You can apply data masking for ComboBox and Text Box. In Access, you can mask the password in two ways. C...

Send Email in Excel VBA using CDO and OLMailItem

Posted on March 21, 2015December 28, 2015 by Wyman W

This tutorial explains how to send email in Excel VBA using CDO and olMailItem. Send Email in Excel VBA using CDO and OlMailItem There are mainly two methods of sending email in Excel VBA. The first method is to use CDO Object, another is to use SendObject Method, I will explain each method in the below sections. Send Email in Excel VBA using olMailItem Object The first method uses olMailItem, it automatically sends email from the active Outlook account. The sender is whoever triggers the Ma...