Access Report VBA: Using Some VBA Report Properties To Automate Your Microsoft Access Reports

Access Report VBA: Using Some VBA Report Properties To Automate Your Microsoft Access Reports

Working and automating an Access report VBA will require some knowledge of the module window (VBE), the defined sections and an insight to pre-defined events for each element of a report design interface.

However, let’s take a step back and identify some of the report properties that can be used in a module that do not appear in a standard design view layout for a report. The three I want to highlight here and you may want to note are:

  1. PrintSection
  2. NextRecord
  3. PrintCount

In fact, to see a full list of report properties, open the Object Browser window (F2 on the keyboard) via the Access VBE window.

access report vba

These hidden properties can be manipulated only during the Access report run time which means the report Continue reading “Access Report VBA: Using Some VBA Report Properties To Automate Your Microsoft Access Reports”

Access Database Forms: Working On Various Ways To Apply Read Only To Your Access Form Design

Access Database Forms: Working On Various Ways To Apply The Read Only State To Your Access Form Design

Whichever version of Microsoft Access you are currently using, working with and designing Access database forms can be time consuming, challenging and unpredictability, misbehave!

The key to a successful form requires two key elements; a) a design plan with scope and b) knowing what form properties to apply to control workflows.

It’s the second aspect I want to highlight in this blog post today and in this example, learning how to set a form and behave as ‘read only’ can be achieved in one of several ways.

To get started, take a quick look at this video tutorial (it’s less than 4 minutes) which demonstrates how to apply a ‘read only’ state for a form.

httpvh://www.youtube.com/watch?v=0GHShQ2On8I

Now the author covers Continue reading “Access Database Forms: Working On Various Ways To Apply Read Only To Your Access Form Design”

MS Access Functions: How To Build A Soundex Or Sounds Like Custom Access VBA Function

MS Access Functions: How To Build A Soundex Or Sounds Like Custom Access VBA Function

Working with MS Access functions (of the built-in variety), you may have noticed a vast list of functions across different categories. By combining (or nesting) functions, you can certainly produce complex output values which will serve you well with your queries, forms and reports.

However, there is one lacking feature (or function) in Microsoft Access that could hinder searching for values and that is a function that can find similar or ‘sounding like’ a string match of characters. This function is widely known as ‘Soundex’ and some database applications do provide their own algorithm to support this technique (including the Soundex SQL Server function).

ms access functions soundex

The algorithm is a phonetic list of character strings based on the pronounced English language and of course this Continue reading “MS Access Functions: How To Build A Soundex Or Sounds Like Custom Access VBA Function”

How To Create A Database In MS Access And Link To MySQL Database

How To Create A Database In MS Access And Link To MySQL Database

Check out and follow these easy steps with this video tutorial (less than 2 minutes) to learn how to create a database in MS Access and link it an MySQL database using the ever popular ODBC connection.

httpvh://www.youtube.com/watch?v=F06hvR6ksh4

The acronym ‘OBDC’ stands for ‘Object Database Connectivity’ and has been around for a very long time now which is now considered the standard for creating a gateway to you MS Access link.

As the video shows, you first establish the database source driver, create an established connection (including a quick test) and then Continue reading “How To Create A Database In MS Access And Link To MySQL Database”