Skip to content

Comeau Software Solutions

Helping you make sense of technology.

  • Home / Contact Us
  • Blog
  • Current Projects
    • New Book! Self-Guided SQL with SQLite
    • Rogue C# Project Page
  • More Resources
    • Find us on Facebook
    • Privacy Policy
  • YouTube Channel

Comeau Software Solutions  provides software consultation, including the development of database solutions. This includes help with Microsoft Access database projects and assistance in moving to other solutions when needed. Please contact us for more information on how we can help you with your project needs.

ComeauSoftware.com also provides learning resources, including tutorials and videos, to help you in understanding today's technology. Please check out the YouTube channel and bookmark this site to stay informed of upcoming projects.


Self-Guided SQL: Build Your SQL Skills with SQLite

Early Release edition
now available on LeanPub!

Search Results for: Microsoft Access

Microsoft Access
How to Programmatically Relink Tables in Microsoft Access / VBA

January 15, 2019

2

Several years ago, I designed a Microsoft Access application called JobSearch Plus for managing job leads during an employment search.  It was a split application, meaning that the tables were stored in one Access file, the back-end, and everything else was in the front-end file with table links to the other one. JobSearch Plus was […]


Read More
How-to
How To Create a Dynamic Search Filter on a Microsoft Access Form

January 9, 2019

10

Best practice when retrieving data in Microsoft Access or any database, for that matter, is to limit the amount of data that you pull at any one time. This means using the proper filters and limiting the number of fields retrieved.  Often, you still end up with a lot of information to look through anyway. […]


Read More
How-to
How to Dynamically Set the Report RecordSource in Microsoft Access

January 8, 2019

0

One of the steps for creating a report in Microsoft Access is to define where the data is coming from.  This is done through the report’s Record Source property which can be a table or standalone query in the database or a SQL statement as shown in the screenshot below. Usually, this is defined when the […]


Read More
Microsoft Access
Splitting a Database in Microsoft Access

February 10, 2016

0

Microsoft Access is unique among all of the Microsoft Office applications in that it can be used to create entire applications that contain large storehouses of data, versatile data entry forms and sophisticated reports to present the data in a variety of ways. It also goes beyond other applications such as Microsoft Excel in that a […]


Read More
Database Design
“Microsoft Access has stopped working” – fixing corrupt files

January 18, 2016

0

Summary Occasionally, when you’re making a lot of design changes to a Microsoft Access database, Access might start crashing when you’re working with that specific database file or when trying to enter the VBA environment with ALT-F11. This leaves you unable to investigate the issue or make further changes. It can be a sign that there are errors within the project’s […]


Read More
How-to
Adding Passswords to Microsoft Access Switchboard Options

November 2, 2015

1

The Switchboard Manager in Microsoft Access makes it easy to create a system of menus that will enable your users to navigate through your application. It also relieves you of the need to manage multiple menu forms and macro calls. Sometimes, however, you might want to keep all but a few users out of specific […]


Read More
Removing Duplicate Records in Microsoft Access

May 26, 2013

0

Introduction (This article was originally written for Access 2002. While the interface in Access has changed somewhat, the principles are still essentially the same for later versions.) Occasionally, you might have a table in Access that contains duplicate records.  Maybe it was imported from one or more sources or perhaps it was not setup with […]


Read More
Articles
Data Analysis with Microsoft Access

May 26, 2013

0

Tackling the Data One of the strengths of Microsoft Access is its ability to import and link to data from different sources.  With Access you can also query and report on the data in ways that a spreadsheet program like Excel doesn’t readily provide.  This can come in handy as part of a database application […]


Read More
Microsoft Access
FREE Course – Managing Your Data with MS-Access

January 23, 2023

0

In early 2020, I created the online course Managing Your Data with Microsoft Access which showed how to create an entire Access application from start to finish. This course has over 5 1/2 hours of video instructions covering the creation of tables, forms and reports along with specialty topics like printing Dymo labels from Access. […]


Read More
Microsoft Access
Recovering a Corrupted Table in Access With VBA

November 16, 2019

0

Recently, a client started experiencing errors, seemingly at random, in the database application I managed for them. The errors immediately started mentioning corruption and then these came through … Error 3167 – Record is Deleted Getting everyone out of the system and running a Compact / Repair seemed to help, but then … “The Microsoft […]


Read More
  • 1
  • 2
  • 3
  • 4
  • …
  • 6
  • Home
  • Contact Us
  • Privacy Policy

Contact Info:
Comeau Software Solutions
P.O. Box 770253
Ocala, Florida 34470

Email: services@comeausoftware.com

© Comeau Software Solutions, 2025. (Theme: WP Minimalist) Free Theme By BlazeThemes.