Send Email in Access VBA using CDO SendObject OlMailItem

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

This tutorial explains how to send email in Access VBA using CDO, SendObject and olMailItem Send Email in Access VBA using CDO, SendObject, OlMailItem There are mainly two methods of sending email in Access 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 Access VBA using SendObject Method To send email using SendObject Method is simple, because it does not require SMTP sever address and port numb...

Send Email in Access VBA using SendObject Method

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

This tutorial explains how to send Email in Access VBA using SendObject Method Send Email in Access VBA using SendObject Method To send email using SendObject Method is simple, because it does not require SMTP sever address and port number. When you run SendObject, whoever run the code will trigger to send email from its Outlook, instead of sending from a specific server email. It is a little bit strange because if you develop an application that sends confirmation email to user who have just ...

Access Continuous Form Conditional Formatting enable issue

Posted on March 18, 2015 by Wyman W

This tutorial explains how to apply Conditional Formatting in Access Continuous Form and issue with enable. Access Continuous Form Conditional Formatting Continuous Form is a Form that shows multiple records in a Single Form. In contract, Single Form shows one record in each page. In VBA, you may change the color of Text Box using If condition, but it only works in Single Form. For Continuous Form, the criteria only checks the first record and apply the format to the rest of all records. To so...

Excel VBA usedRange Property and reset usedRange

Posted on March 13, 2015December 22, 2015 by Wyman W

This tutorial explains how to use Excel VBA usedRange Property to find the last used row and column number, and reset usedRange. You may also want to read: Excel VBA custom Function last row and last column Excel delete blank rows and blank cells before import into Access Excel VBA UsedRange Property Excel VBA UsedRange is a worksheet Property, it returns the area Range bounded by first used cell and last used cell. "Used Cell" is defined as Cell containing formula, formatting, value th...

Excel VBA custom Function last row and last column

Posted on March 12, 2015March 23, 2017 by Wyman W

This tutorial explains how to create a custom VBA Function to find the last row and last column number in Excel worksheet. You may also want to read: Excel find the last row using Worksheet formula Excel VBA custom Function last row and last column In Excel VBA, we always need to loop through each Cell to perform some actions. For Range that you already know, you can easily use For...Each Loop to loop through each Cell for a specified Range as below For Each rng in Range("A1:C10") ...

Excel Workbook Calculation Automatic and Manual

Posted on March 12, 2015January 30, 2017 by Wyman W

This tutorial explains Excel Application Calculation Automatic and Manual. You may also want to read: Excel VBA Application Volatile Method Excel Workbook Calculation In Excel worksheet, there are three options under Workbook Calculation. Explanation of Excel Workbook Calculation Options Excel Option Description Automatic Default option. Recalculation occurs when- Edit a Cell- Open workbook- Add / Delete / Hide / Unhide row - Rename worksheet - Reorder worksh...

Excel VBA Application Calculation Property

Posted on March 11, 2015March 12, 2015 by Wyman W

This tutorial explains Excel Application Calculation Property and difference among xlCalculationAutomatic, xlCalculationManual, xlCalculationsemiautomatic Excel VBA Application Calculation Property In Excel worksheet, there are three options under Workbook Calculation. The options in Workbook Calculation uses Calculation Property in Excel VBA, which means if you execute the corresponding VBA code, the Excel options change accordingly. Excel Option Description VBA Automatic...

MPF Ordinance in Hong Kong

Posted on March 8, 2015July 16, 2015 by Wyman W

MPF Ordinance in Hong Kong This tutorial explains the core concepts of MPF Ordinance in Hong Kong. All data were updated as at 2015 March, I may not be able to constantly update the Ordinance. MPF Enrollment Permitted Period is the period within which an employer must enroll employees in an MPF scheme. Employment type Permitted Period Non casual employee the first 60 days of employment Casual employee the first 10 days of employment Self employed person the first 60 ...

Excel Access MRound custom Function round to nearest multiple

Posted on March 8, 2015October 4, 2016 by Wyman W

This tutorial explains how to create a custom Excel Access MRound Function to simulate Excel spreadsheet MRound Function round to nearest multiple Excel MRound Function Excel Round Function is used to round to nearest digit, while Excel MRound Function is used to round to nearest multiple. The first time I used MRound Function is to round employee bonus to nearest $100, because we want the bonus amount looks better. For example, $11040 is rounded to $11000. Access MRound Function As of Acces...

Excel MRound Function round to nearest multiple

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

This tutorial explains how to use Excel MRound Function round to nearest multiple Excel MRound Function round to nearest multiple Excel Round Function is used to round to nearest digit, while Excel MRound Function is used to round to nearest multiple. The first time I used MRound Function is to round employee bonus to nearest $100, because we don't want the bonus amount looks better. For example, $11040 is rounded to $11000. If you fail to use Excel MRound Function, navigate to Developer &g...