Tag Archives: Forms

No Thumbnail

Access Startup Form

Previously in the article Open Form When Database is Opened, Access I’ve explained how you can use an “Autoexec” macro to open a certain form every time the access file is opened. In this article another method will be explained. – Step 1: Click on the File button: –

DLookUp, Access Expression Builder

This article will explain the DLookUp function used in the Access expression builder. – Syntax: =DLookup(expr, domain [, criteria] ) expr: The field whose value will be returned. String expression. domain: The set of records where the value will be retrieved from. String expression. criteria:

No Thumbnail

Access Create Popup Form

This article explains how to create popup forms like the one below in Access: – Step 1: Open the form in design view: – Step 2: Change the Popup property to “Yes”: See also: Open Form When Database is Opened, Access Access Form Design View

No Thumbnail

Access VBA, Referencing Forms

In this article I will explain how you can reference access forms using VBA. For example: Form_MyTable1.Recalc Form_MyTable1.Requery Form_MyTable1.Controls.Item (1) Form_MyTable1.Width = 45 but before this can be done the Form_MyTable1 needs to be created. This can be done by following the steps below: – Step 1: Double

Access Form, Populate TextBoxes Based On ComboBox

In this article I will explain how you can create textboxes in an Access form that will be filled based on the value selected from a combo box and a Table. The Access form has multiple textboxes and a single combo box. The user will be able

No Thumbnail

Access Forms, Fields From Multiple Tables

This article explains how you can create a form which gets its data from multiple tables. Note that access forms can only get data from one table or query. Attempting to use expressions that reference fields from multiple table will result in the #Name? error. A workaround

No Thumbnail

Open Form When Database is Opened, Access

This article explains how to cause a form to open when an Access database is opened. Step 1: From the Create ribbon click on the Macro button: The following window will open: Step 2: Select OpenForm from the drop down list: Step 3: From the

No Thumbnail

Open Blank Form When Database is Opened, Access VBA

Previously in the article Open Form When Database is Opened, Access I’ve explained how you can cause a form to appear every time the an Access file is opened. By default the form will be displaying the first record in the table: In this article I will

No Thumbnail

Access, Convert User Input to Uppercase

This article explains how to convert user input to uppercase in Access. This applies to user input in Tables and Forms. – Tables: Open the table in design view: Select the field you would like its values to be converted to uppercase. Change the format

No Thumbnail

Access Field Properties Locked

This articles explains the reason why the field properties of a table become locked and unmodifiable: – Why? The main reason, that the field properties get locked is because you have a form associated with the table open: Once the form is closed, the field