How to Convert Text or String to Lowercase, Uppercase, and Propercase

How to Convert Text to Lower Case, Upper Case, and Proper Case Many people think formatting text is a small part of programming. However, it appears to be an important part of the program and database. When the formatting function is integrated to the entry form, it will provide a convenience to the users. It will auto convert to correct the data format event though the user enters wrong format. It will keep consistency of data in the database. Also the input data will be recorded in the same format…

Read More

How to Use Browse To

How to Use Browse To in VB and Macro In this how to I will show to use Browse To command in both VB and Macro. The word “Browse” means “To look at or through something to see what is there” per Cambridge Dictionary. In MS Access, we use Browse To to jump from one form to another form. In this How To, I will show how to use Browse To to jump from the Alert Form to the second tab of Navigation Form. We have a tab of task…

Read More

Macro: How to Transfer Data from Form to Report

Macro: Transfer Text from Form to Report (VB: Transfer Text from Form to Report) In this How To, I will show you how to transfer data from textbox on form to report. Data on the textbox is not stored in the table. For example below, I have two textboxes on the form for start and end date. I want to open a report by the date range from the start date and end date that I enter on the form. I also want the date range to show on the…

Read More

How to Print Report on MS Access

How to Print Report In this How To, I will show you how to print a report. Users can print out all records or a specific record or range of records. The user can use either VB code or Macro to print as I will show the how to below. There are two most common methods to print. Print Preview Report: The user will see how the report looks like before printing. The Print Preview toolbar will display on the Navigation toolbar that allow to print and to do other…

Read More

How to Print Form in MS Acccess

How to Print Form In this How To, I will show you how to print a form. It can print out only one page or many pages or by option. You can use either VB code or Macro to print as I will show the how to below. The method below can also be used under the Navigation form environment as well. Print Form One Page Only After you selected a customer then click Print, it will print out one record or maybe more than one records per page depending…

Read More

How to Set Program to Close Automatically

Set Program to Close Automatically MS Access program can be closed automatically if there is no activity. In this How To, the method of detecting the idle on active form and active control will be used. The idle time will count when a new form is opened or get focus and/or a control is changed within the active form. There are three steps to make this happen. Create a Detect Idle Time form Apply the VB code on the Timer event procedure Create Macro to load the Detect Idle Time…

Read More

How to Convert Access Macro to VB code

Converting Access Macro to VBA code Easy The Embedded Macro is a popular method that used in the sample Access file version 2007, 2010 and 2013 from Microsoft. The Embedded Macro is used to collect a group of commands that require only few of input for each command from the developer. It also can be copied easily from one location to another. When a button is copied to a new location the Macro command of that button will stay with a new button, not like an Event Procedure. The sample…

Read More