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 Excel Scripting Dictionary store unique array item

Posted on April 7, 2015February 26, 2017 by Wyman W

This Access Excel tutorial explains how to use Scripting.Dictionary in VBA to store unique array item. You may also want to read: Access Excel VBA Array Remove duplicates in text using Dictionary Access Excel VBA Scripting.Dictionary to store unique array item An associative array, map, symbol table, or dictionary is an abstract data type composed of a collection of (key, value) pairs, such that each possible key appears just once in the collection. Put it simply, you can avoid duplica...

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 Excel Generate random HKID Hong Kong ID card number

Posted on April 5, 2015March 17, 2016 by Wyman W

This Access Excel VBA tutorial demonstrates how to generate random HKID / Hong Kong ID card number. You may also want to read: Access Excel Function HKID Check Digit (last digit) Excel VBA Rnd Function to generate random number Excel generate random letter A to Z using RANDBETWEEN Assign unique random number using Excel Access Excel Generate random HKID (Hong Kong ID card number) The purpose of this article is to generate a random HKID (Hong Kong ID card number) that has va...

Excel generate random letter A to Z using RANDBETWEEN

Posted on April 5, 2015March 20, 2016 by Wyman W

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

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

Excel timer countdown for test using Application.OnTime

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

This Excel tutorial shows how to make Excel timer countdown for test using Application.OnTime You may also want to read: Excel VBA Application.OnTime Method to schedule event with timer Send Email in Excel VBA using CDO and OLMailItem Excel timer countdown for test using Application.OnTime If you are going to job interview, you may be asked to do an Excel test. I have been thinking it would be awesome to make a countdown in the worksheet to tell the interviewee how much time is left. ...