Workshop 4: Access VBA, Design and Advanced Methods

Implement instant search in access forms with VBA, navigate matches using plus and minus keys, and manage bookmarks with a field-aware search using screen active control and application.echo.

fix the last screen problem in access vba by computing screen capacity from inside height and form header, then using absolute position and recordset to stay on the correct record.

Identify and fix the apostrophe problem in Access VBA by translating key codes to the correct apostrophe for name searches, and use debugging tools to handle apostrophe driven syntax errors.

Create a reusable VBA function fix AP to fix the apostrophe problem in database searches by using a module, option explicit, and the replace function.

Explore how themes control colors and fonts in Access, view theme options in design view, and switch or save color and font sets to apply consistent styling across forms.

Learn to select color sets, create color themes, and adjust fonts for headings and body text. Save and name your themes, and export them for use across Access and Excel.

Learn how to customize and save Access themes, including color sets and fonts, save them as theme files or XML templates, and share them across networks to standardize the look.

Match website and logo colors precisely using ColorCop, grab exact RGB and hex values with the eyedropper, customize Access themes, and save or distribute color themes across computers.

Explore printing the form record with a print workflow, including print, save as pdf, and close buttons, plus a query to identify order with the most products via a report.

Learn why a form can't print with headers and how a separate report with a page header yields print-ready results, using a query and a copied form to illustrate.

Save the form and its subform as reports using save object as, then use the wizard to insert a subreport and configure the print to reflect the current record.

Modify the new orders print to show only the current record by using the orders form's order number in the report's record source criteria.

Learn to add a report header and page header in Access VBA, ensure headers repeat on each page, and implement a print button with print preview for the orders report.

Add a save as pdf button on the orders form. Name the pdf from the order number and up to five letters of the last name, then output the pdf.

Explore a redesign of a customer survey database from a single form to surveys, questions, and survey_questions tables. Emphasize prioritizing reporting over data entry to keep questions and answers consistent.

Focus on building a transaction table to simplify reporting, linking survey questions to surveys and dates, then create efficient queries in May to count yes responses by product category.

Write vba for the create survey button to auto create a new survey, update the customer name from the customer id, and confirm with a message box, handling first-record cases.

Add VBA code to the add questions button to check for existing questions, build and run an append query to populate survey questions, then refresh the form.

Review the workshop highlights on form manipulation, absolute position, inside measurements, fixing apostrophes with a VBA function, and creating reports and PDF exports from surveys using themes.