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 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 Show Navigation Pane and Ribbon Menu

How to Show Navigation Pane and Ribbon Menu I would like to thank many of you who purchased the example Access files or made a donation to my website. Some of the example files do not have the Navigation Pane or Ribbon Menu. So I create this How To in order to bring back the Navigation Pane and Ribbon Menu. For example, the Student Database file does not display the Navigation Pane or Ribbon when you open the Access file. Press F11 to Show Navigation Pane  You can bring the…

Read More

How to Open MS Access file from EXE file

How to Convert Batch file to EXE file and Open MS Access file from Exe file Normally, the user opens the MS Access file by double clicking on the MS Access file. The Access file can also be opened directly from the Exe file. The Exe file is the executable file which transforms a source file into an executable file. In this how to, I will show how to create a BAT file to open the Access file then convert the BAT file to the EXE file. The main reason…

Read More

How to Hide Navigation Pane, Full Menu, and Shortcut Menu

How to Hide Navigation Pane, Full Menu, and Shortcut Menu The main purpose of hiding the Navigation Pane, Full Menu, and Shortcut Menu is to prevent users to see the table list, queries, forms, reports, and modules. It also appears to be professional looking. The Access file will display the Navigation Pane after open as shown on the Figure 1. After hiding, there is no full menu and no Navigation Pane when Access file is opened (see Figure 2). Figure 1 Figure 2 Step by Step of Hiding Navigation Pane,…

Read More

How to Design and Create Database Table

How to Design and Create Database Table in MS Access Database is a structured set of data held in a computer, especially one that is accessible in various ways per Google.com. Database is a set of data grouped together in one location in (or accessible by) a computer. A computerized database has been likened to an electronic filing cabinet of information arranged for easy access or for a specific purpose (dictionary.com). Planning How will we create a database in MS Access? Before we will create a table for database, we will consider these factors: What type of database we will create? What kind of data or information we need to use? How the each data related to each other? Can we group those…

Read More

How to Set Temporary Value (Set TempVars)

How to Set Temporary Value While we are using the Access program sometime the same information was used in different place/form even in report. The same information on the new form is related or linked to another form. We can use the method of setting TempVars ( for Temporary variables) on the original form instead of parsing or referencing the value from the original form to a new form. TempVars is a Variant store that only exists while a given solution/database is open. We can set or store the Temp…

Read More