Workshop 5: Access VBA, Design and Advanced Methods

Learn to implement range filters in Access VBA with two combo boxes for a date range, and build dynamic filter strings for state and city filters.

Create and test the got focus and lost focus subroutines, implement beginning and ending date filters, and build the filter string with after update and clear button logic.

Update the buildFiltStr subroutine to add beginning and end date filters using greater than or equal to and less than, switch date literals to pound signs, and test with records.

Explore how VBA in Access tackles the option buttons limitation by using an option group, mapping numeric values to text, and updating the how found field.

Use Access VBA to populate the invisible how found box from the how found field. Map selections with the choose function and update the current record on after update.

Learn to fix accidental option clicks in Access forms by adding a none option, using after update with a choose function to blank the how found field.

Design common postal labels in Access by laying out a 51 60 label with name, address, city, state, and zip, then sort by customer ID and enable multi-column print preview.

Create a custom label format in Access VBA by defining a 2.5 by 3 inch label, adjusting margins and inter-label spacing, and configuring page setup for multi column printing.

design a multi-column roster in access vba from scratch, set margins for four columns with zero spacing, add borders and header/footer, and preview the print layout.

Fix the multi-column Access VBA report by removing text box borders, refining layout in print preview, and applying group and sort by last name and first name.

See how I use the database documenter to generate concise reports on tables, queries, and forms, adjust options to exclude field properties, and export to Excel when needed.

Define the objective of creating a VBA subroutine to replace the date parameter query, use a worktable, and orchestrate make-table and append queries for an orders by date report.

Extend the Access VBA subroutine by testing for zero records with dcount, adding a mark field, and creating a make table and append queries for unique order dates.

Learn to build an Access VBA form to select dates, using a tabular form with a checkbox bound to a field, a done button, and dialog mode for controlled closing.

Learn to update the orders by date table by selecting specific dates, using an update query to set mark true, and a delete query to remove unselected dates.

Add a red 'for selected dates only' label under the report header and reveal it only when a dates selection exists.

Master access VBA techniques to set date ranges, use range filters, enhance option buttons with minimal code, and design labels, multi-column reports, and date-based reports with the database documenter.