Want a good read? Try The Summer of His Life 

In 1969, twelve-year-old Mike is forced to spend the entire summer at a cottage on a small lake in Michigan with his ancient aunt and uncle. Most days are spent pursuing adventure with his buddies, seeking to emulate their son, a tough Marine in Vietnam, but when the Marine son is declared Missing In Action, Mike’s vision of government, God, and his own life is shattered. His joy-filled expeditions into the wild become pointless in the light of his cousin’s sacrifice. However, when Mike learns that the father of the girl-next-door has a violent secret, Mike knows exactly what to do. Bravery and manhood are merely doing what he knows he should do. Of course, the story is about Mike, but it is also about a unique time and a wondrous place viewed through the enchantment of a 12-year-old’s imagination. We hear wild stories of manly exaggeration, but his painfully written journal takes us inside a crumbling, fragile heart. It is the summer of his life, and sometimes it takes tears to let in the joy.

* Index to Roger’s Access Blog *

Access Basics

• How do I Create an Application in Microsoft Access?
• How Do I Convert A Macro to VBA Code?
• How Do I Configure My Access Database Start Up?
• How Do I Bypass Start Up Options?
• How do I run a macro or code when the database first starts?
• How Do I Turn Off Compact On Close and Name Auto Correct in Access on Start Up?
• How Do I Disable Layout View for Forms and Reports at Start Up?
• How Do I Maximize an Access Database at Start Up?
• How Do I Minimize the Ribbon In Access at Start Up?
• How Do I Minimize the Access Navigation Pane on Start Up?
• Can I Create an EXE from my Access Application?
• How Do I Decompile a Database?
• How do I add a value to a combo box with Not In List?
• What To Do When You Take Over A Database Application

Compacting Databases

• What Does It Mean to Compact My Access Database?
• How Do I Compact an Access Database?
• Should I use the Compact On Close feature of Access?
• How Can I Compact the Current Access Database in Code?
• How Can I Compact my Access Database Less Often?
• Help! My Database is Corrupted, and I Can't Repair!

Domain Functions Demystified

• Domain Functions Demystified: Introduction
• Domain Functions Demystified: Criteria Expressions
• Domain Function Example: Simulate AutoNumber with DMax
• Domain Function Example: Numbered Query With DCount
• Domain Function Example: Running Sum with DSum
• Domain Function Example: "Difference Between" in Query 
• Domain Function Example: Rolling Average in Query
• Domain Function Example: Begin Date and End Date from Effective Date
• How do I calculate a Median in Access? Part1
  • How do I calculate a Median in Access? Part 2

Date Stuff

• Date Functions
• Date Stuff–Using the Functions
• Date Stuff – Useful Examples
• Now() Function in Default Value Stores the Wrong Time

 Database Design Basics

• Really Bad Design Decisions: A Case Study
• What is a Primary Key?
• What is an Index?
• What does NULL mean? How is it different than the Empty String?
• Normalizing City, State, and Zip
  
  What is Normalization?
• What Is Normalization, Part I: Why Normalization?
• What Is Normalization, Part II: Break it up.
• What Is Normalization: Part III: Putting It Back Together
• What is Normalization: Part IV: More Relationships
• What Is Normalization: Part V: Many-to-Many Relationships
  
  Entity-Relationship Diagramming
• Entity-Relationship Diagramming: Part I
• Entity-Relationship Diagramming: Part II
• Entity-Relationship Diagramming: Part III
• Entity-Relationship Diagramming: Part IV
  
  The Normal Forms
• The Normal Forms: Introduction
• The Normal Forms: First Normal Form (1NF)
• The Normal Forms: Second Normal Form (2NF)
• The Normal Forms: Third Normal Form (3NF)
• The Normal Forms: In a Nutshell

What’s Wrong With Repeated Columns?

• The Problem of Repeated Columns
• Querying Repeated Columns: Multiple ORs
• Querying Repeated Columns: Multiple Unions
• Querying Repeated Columns: Multiple Joins
• Querying Repeated Columns: Multiple IIFs
• Querying Repeated Columns: Impossible Joins
• Aggregating Across Repeated Columns: Summing
• Aggregating Across Repeated Columns: Counting
• Aggregating Across Repeated Columns: Averaging

Normalizing Repeating Columns

• Normalizing Single Repeated Column (Part1)
  • Normalizing Single Repeated Column (Part2)
• Normalizing Multiple Columns (Part1)
  • Normalizing Multiple Columns (Part 2)
• Normalizing Yes/No Fields (Part1)
  • Normalizing Yes/No Fields (Part2)
• Normalizing Repeated Columns With VBA

Queries

• What Is A Query?
• This Recordset is Not Updateable. Why?
• Searching for a Wildcard in a “LIKE” Criteria (Quick Tip)

Select Queries Series:

• Part 1: Simple Queries
• Part 2: Restricting Rows - the Where Clause
• Part 3: Sorting and Grouping (ORDER BY, GROUP BY)
• Part 4: PARAMETERS, TOP, DISTINCT, and TRANSFORM...PIVOT

Subqueries

• How do I create a Numbered Query in Access?
• How do I create a Running Sum Query?

Union Query

• Union Query Part 1: Simple Union Query
• Union Query Part 2: More Union Queries
• 
  Joins
• What is a Join: Part 1 (Introduction)
• What is a JOIN: Part 2 (Inner Join)
• What Is A Join: Part 3 (Cartesian Joins)
• What is a Join: Part 4 (Equi-Joins in the WHERE Clause)
• What Is A Join Part 5: Outer Joins
• Why Do I Get the "Ambiguous Outer Join" Error
  
  Action Queries:
• Running Action Queries In VBA
• Delete Query
• Update Query
• Append Query
  • Append Queries: Avoiding Duplicates
• Make-Table Query 
• Featured Sample: UnboundSQL.mdb

Data Definition Language (DDL) Queries:

• SQL vs. DAO
• DDL Using SQL
• DDL Using DAO

Top Queries Revealed:

• Simple Top Query
• Aggregate Values and Top Values By Group.
• Top Query Problem - Ties
• Top Query to find Random Records
• Parameters in Top Queries

Count Distinct In Access Series:

• COUNT DISTINCT in Access: Part 1
• COUNT DISTINCT In Access: Part 2
• COUNT DISTINCT In Access: Part 3
• COUNT DISTINCT In Access: Part 4
• COUNT DISTINCT in Access: Part 5

Miscellaneous

• What is the fastest way to return the Record Count of a table?
• What is the fastest way to return the Record Count from an Access Query?
• What is the difference between HAVING and WHERE in Aggregate Queries?

Reports

• Showing Query Parameters in a Report (Quick Tip)

VBA/Programming

• Bang Vs. Dot In DAO
• Bang Vs. Dot in Forms
• Referencing Forms, Subforms, and Sub-subforms
• Data Definition Language (DDL): DDL Using DAO
• De-identifying Data for Confidentiality - Part I
• De-identifying Data for Confidentiality - Part II 
• How Do I Find The Path and Filename For My Database?
• How Do I Replace System Error Messages With Custom Messages?
• How Do I Convert A Macro to VBA Code?
• How Do I Hide a Form But Leave It Running?
• How Do I Run A Process Automatically Once A Day? Part 1
• How Do I Run A Process Automatically Once A Day? Part 2
• What’s the Difference Between Early Binding and Late Binding?
• How do I calculate a Median in Access? Part1
  • How do I calculate a Median in Access? Part 2
• Recreate Access Tables in SQL Server

Automation

• How do I export Access data to Excel - Part 1
• How do I export Access data to Excel - Part 2
• How do I export Access data to Excel - Part 3
• Easy Excel Charting from Access
• Automating Microsoft Word and Excel from Access
• What’s the Difference Between Early Binding and Late Binding?

Web Databases
Unfortunately, as of Access 2019, Access Web Apps have been discontinued.  From the March 2017 announcement from Microsoft:

“We no longer recommend Access Services for new apps. This feature will be retired from Office 365. We will stop creation of new Access-based apps in SharePoint Online starting June 2017 and shut down any remaining apps by April 2018.”

• The Data
• How Can I Put My Access Database On The Web?
• Web Compatibility
• How can I create a Compound Unique Index?
• Creating Relationships
• Uploading to SharePoint
• Viewing Tables In SharePoint
• Other Compatibility Errors   

Domain Function Builder

Application to help build domain functions including:

1. Correctly formatted Criteria
2. DMax Sequential numbering
3. Numbered Query
4. Running Sum Query
5. Rolling Average Query
6. Difference Between Query
7. Infer End-Date Query

You can download the file here:DomainFunctionBuilder_BetaV1-1.zip

How Do I Turn Off Compact On Close and Name Auto Correct in Access on Start Up?

Create a function called SetMyOptions()

Function SetMyOptions()

'turn off Compact On Close
    Application.SetOption "Auto compact", False

'turn off Name Auto Correct
    Application.SetOption "perform name autocorrect", False

End Function

Run this function in an AutoExec macro.

How do I run a macro or code when the database starts?

How Do I Disable Layout View for Forms and Reports in Access at Start Up?

Create a function called SetMyOptions()

Function SetMyOptions()

'disable Layout View for forms and reports
    Application.SetOption "DesignwithData", False

End Function

Run this function in an AutoExec macro.

How do I run a macro or code when the database starts?

How Do I Maximize an Access Database at Start Up?

Create a function called SetMyOptions()

Function SetMyOptions()
'maximize Access
    Application.SetOption "maximized", True
End Function

Run this function in an AutoExec macro.

How do I run a macro or code when the database starts?

How Do I Minimize the Ribbon In Access at Start Up?

Create a function called SetMyOptions()

Function SetMyOptions()
'minimize Ribbon

     If Not (CommandBars("Ribbon").Controls(1).Height < 100) Then
        CommandBars.ExecuteMso "MinimizeRibbon"
     End If

End Function

Run this function in an AutoExec macro.

How do I run a macro or code when the database starts?