Create Save button and a Notification to Save a Change

 How to Create a Save button and a Notification to Save a Change  With the bound fields on form, Microsoft Access will automatically save any changes that we update on fields because the control source of data is linked to the field in table. Whether we close the form or move to a new record it will automatically save the changes. In this How To, I will show you a way of creating a notification to save the changes with a Save button. It gives an option to the users…

Read More

How to Create a Notification to Save a Change

How to Create a Prompt to Save a Change With the bound fields on form, Microsoft Access will automatically save any changes that we update on fields because the control source of data is linked to the field in table. Whether we close the form or move to a new record it will automatically save the changes. In this How To, I will show you a way of creating a notification to save the changes. It gives an option to the users to save or cancel the change. It will make…

Read More

How to Display a Default Text on Combobox

How to Display a Default Text on Combobox Normally, a combobox will be blank when a form is loaded. We will see a list of items when we click on the combo box drop-down list. In this How To, I will demonstrate how to display a default text on the combobox when form is loaded step by step below: Step 1. Add Combo Box Add Combo box Name it as Combo9 We need a combobox of all customers from the Customer table. If you don’t know how to create the…

Read More

How to Transfer Items from Combobox to Listbox

How to Transfer Items from Combobox to Listbox A combobox collects items and displays as a list under the drop-down list. Normally the combobox contains a list of items from table and can be selected once at the time from the drop-down list. However, the items can also be manually added into the combobox. A list box is a collection of items like combobox, but displays as a list one item per line in the rectangle box. In this How To, I will demonstrate how to copy or transfer the…

Read More

Function Check If Folder Exists

Function Test If Folder Exists VBA Code: Function FolderExists(sFile As Variant) As Boolean On Error Resume Next If Len(sFile) > 0 Then     FolderExists = (Len(Dir$(sFile, vbDirectory)) > 0&) End If End Function How to Use It: Put the VBA code above on form or in the Module and call it on the click button on your Access file where you want to check if this form exists before call process the next step. If you call a certain folder or file path that does not exist then you will get…

Read More

How to Get the Last Value of Certain Field

How to Get the Last Value of Certain Field In this How To, I will show how to get the last value of certain field from the last record. Sometime, we need a specific value of the last record. For this example, I need to get the value in Balance field from the last record which is $300.00 per the picture below. The last record is the ID field that has the biggest number which is 144. I will use DLookUp and DMax functions together to get the value $300.00…

Read More

How to Clear Items from Listbox

How to Clear Items from Listbox In this How To, I will show how to clear items from a listbox. I will use the form that I created for How to Add Items from File Dialog to Listbox and add a Clear List button. Step 1. Add Clear List button Under the Design Menu, click a Command button icon then place it below the Add File button Rename a button caption as Clear List Name a button under the Other tab of Property Sheet as cmdClearList Click Event tab of…

Read More