Access error Type Num Div/0 Num

Posted on March 28, 2015 by Wyman W

This tutorial explains the cause of Access errors in Access Query, Report, Form. These include #Error #Type! #Num! #Div/0! #Name. Access error #Error #Type! #Num! #Div/0! #Name There are several very common errors you may encounter in Access Query, Report or Form. It is very useful to understand the error in order to fix it, otherwise you will need to spend a lot of time to find out what Access is trying to tell you. Access error #Error! Access error #Error! occurs in an Expression where you...

Access Report keep a group together in one page

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

This Access tutorial explains how to keep a group together in one page in Access Report. You may also want to read: Access Report group by date problem Access Report - keep a group together in one page In Access Report, you can group a Field and then display the grouping in Group Header, and display the value in Details. Sometimes the Details may be so long that it extends to the next page, breaking up the same group into two pages. Access Report has a function called "group together i...

Access Rnd Function generate random number and decimal

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

This Access tutorial explains how to use Access Rnd Function to generate random number and create custom Function for random decimal number. Access Rnd Function to generate random number Access Rnd Function is for use in Access, Access VBA, Excel VBA, it is used to generate random number larger than 0 and smaller than 1 (1 and 0 exclusive). Syntax of Access Rnd Function Rnd[(number)] Number Rnd generates Not supplied or any positive number Generate a new random number 0 R...

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...