Access create search Form

Posted on May 1, 2015May 1, 2015 by Wyman W

This Access tutorial explains how to create a search Form with multiple criteria. You may also want to read: Access DoCmd.OpenForm Method to open Access Form Access Combo Box value depends on another Combo Box Return Access Form input to Access Report or Form or Query Access create search Form with multiple criteria Sometimes you need to create a search Form where users can select specific criteria. The simplest solution is to directly filter data for each field like using AutoFi...

Access convert Table Query Report Form to Report Form

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

This Access tutorial explains how to convert from one Object to another, such as Query to Form/Report, convert Form to Report. Access convert Table, Query, Report, Form to Report or Form There are several kinds of conversion you can do among Access Objects. For example, convert a Form to Report, convert a Query to Form, etc. Suppose you have created a Query and you want use to print it out as Report, it would be a pain to move everything to the Report. Instead, you can simply do an automati...

Access DLookup and lookup multiple criteria

Posted on April 5, 2015 by Wyman W

This Access tutorial explains how to use DLookup Function to lookup value in Query or Table, and demonstrate how to DLookup multiple criteria. You may also want to read: Access user login Form and verify password Access DLookup Function and lookup multiple criteria DLookup Function is very similar to Vlookup of Excel, the purpose is to look up the first matched value of particular Field from another table. To describe more precisely, DLookup is same as a SQL Select statement, but brea...

Access user login Form and verify password

Posted on April 4, 2015 by Wyman W

This Access tutorial demonstrates how to create user login Form, verify password, create user level / privilege You may also want to read: Access Form mask Password Text Box Auto Run Access Form using AutoExec Access user login Form There are many tutorials in Google about making user login Form, some of them make a lot of error handling and conditions. The one I am going to demonstrate must not be the best, but will fulfill your basic requirements. Step 1 - Create a Table Create ...

Access Combo Box value depends on another Combo Box

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

This Access tutorial explains how to use Combo Box in Form where one Combo Box value depends on another Combo Box. You may also want to read: Access Form Combo Box and save selected value Access Combo Box value depends on another Combo Box In this tutorial, I will demonstrate how to use Combo Box in Access Form where one Combo Box value depends on another Combo Box using the below Login Form as an example. The Login Form contains two combo boxes - comboDivision: Contains a list of ...

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