Add dropdown list in Access Table Field

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

This Access tutorial explains how to add dropdown list in Access Table Field using List Box and Combo Box. Add dropdown list (Combo Box) in Access Table Field Suppose you have two tables. Personal_data - store personal information of employees Personal_data Employee_ID Employee_Name 001 Sam 002 Apple 003 May Job_data - store the position title of an employees Job_data Employee_ID Position 001 HR Manager For an HR database, a ...

Set password for Access database to protect back end database

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

This Access tutorial explains how to set password for Access database to protect back end database. You may also want to read: Access user login Form and verify password Set password for Access database to protect back end database If you are making an Access application for multiple users, it is a good practice to create a front end application and back end database. You should store all tables /Modules in back end and lock it with password. For front end, create user forms / query...

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 generate random letter A to Z using Rnd

Posted on April 5, 2015 by Wyman W

This Access tutorial explains how to generate random letter A to Z / a to z or a mix using Rnd Function. You may also want to read: Excel generate random letter A to Z using RANDBETWEEN Access generate random letter A to Z using Rnd In order to generate random letter, we have to make use of two Functions. - Rnd - Chr In the below sections, I will briefly go going through these two Functions. For details, click on the link above. Access generate random number using Rnd Access R...

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 BETWEEN timestamp problem

Posted on March 31, 2015 by Wyman W

This Access tutorial explains the problem with BETWEEN timestamp, where the end date is not included in the result. Access BETWEEN timestamp problem - end date not included Very often you may receive data source that uses timeStamp (for example, 1/1/2015 15:34:00) instead of a Date (1/1/2015). The purpose of timestamp is to accurately record the time of action for auditing. In Access (even other system), you may want to select data within specific date period, say, between 1/1/2014 and 1/...

Access count substring in string or text

Posted on March 29, 2015September 15, 2015 by Wyman W

This Access tutorial explains how to count substring in string (text). Access count substring in string (text) Access does not have a buit-in Function to count substring in string (text), instead you need to work around to get the job done. Alternatively, I have made a VBA solution for your reference. Access count substring in string using Len and Replace Function Access Len Function is to measure the length of text. Access Replace Function is to replace a substring in a text. To cou...

Compare difference between two tables in MS Access Query

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

This Access tutorial explains how to compare difference between two tables in MS Access Query Compare difference between two tables in MS Access Query Access does not have a built-in Function to compare difference, but since we can write SQL and design Query in Access, we can make use of the properties of SQL JOIN to compare difference. There are three kinds of JOIN in SQL - Inner Join, Left Join, Right Join. Assume that you have two tables, table1 and table2, where you join them using a...