Comeau Software Solutions

Making sense of technology since 2000.

Menu
  • Home / Updates
  • Services / Contact Us
  • Rogue C# Project Page
  • More Resources
    • YouTube Channel
    • Ocala I.T. Professionals
    • Personal Site
Menu

Search Results for: Microsoft Access

How to Dynamically Set the Report RecordSource in Microsoft Access

Posted on January 8, 2019February 18, 2023 by Andrew Comeau

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

Splitting a Database in Microsoft Access

Posted on February 10, 2016February 18, 2023 by Andrew Comeau

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

“Microsoft Access has stopped working” – fixing corrupt files

Posted on January 18, 2016February 18, 2023 by Andrew Comeau

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

Adding Passswords to Microsoft Access Switchboard Options

Posted on November 2, 2015February 14, 2023 by Andrew Comeau

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

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

Data Analysis with Microsoft Access

Posted on May 26, 2013February 14, 2023 by Andrew Comeau

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

FREE Course – Managing Your Data with MS-Access

Posted on January 23, 2023February 18, 2023 by Andrew Comeau

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

Recovering a Corrupted Table in Access With VBA

Posted on November 16, 2019December 2, 2019 by Andrew Comeau

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

Troubleshooting MS-Access Error 31532 – Unable to export data.

Posted on September 11, 2019February 18, 2023 by Andrew Comeau

Microsoft Access can sometimes seem to have its own obstinate personality, throwing errors that persist no matter what you try. I wanted to share a recent troubleshooting experience to show some of the steps that you can take when a function is just not working as expected and the decision process involved in fixing it.

Read more

Deploying MS-Access Table Design Changes to Remote Files

Posted on August 7, 2019February 18, 2023 by Andrew Comeau

A New Challenge for Access I designed a Microsoft Access database for one of my clients and it’s split into two files – a front-end file with all the forms, reports and code and a back-end file with the tables. That’s pretty standard. During the development process, I needed to make adjustments to the table…

Read more
  • Previous
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • Next

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

Comeau Software Solutions also provides software consultation, including the development of database and productivity solutions, in Ocala, Florida. This includes rescuing Microsoft Access databases and other legacy projects and providing assistance when it's time to move to another solution. Please contact us for more information on how we can help you with your project needs.

Available on Amazon.com


Premier Protein Shake - 24 Vitamins & Minerals/Nutrients
12 flavors to choose from and 24 vitamins and minerals. Control your hunger with 30g of protein per bottle and only 1g of sugar.

Premier Protein
  • Articles
  • C#
  • Careers
  • Commentary
  • Database Design
  • Databases
  • Hardware
  • How-to
  • Humor
  • Internet
  • Jobs
  • Linux
  • Microsoft Access
  • MySQL
  • Ocala I.T. Professionals
  • Personal
  • Personal Tech
  • Programming
  • Resources
  • Reviews
  • Rogue C# Series
  • Software
  • SQL
  • Uncategorized
  • Web Design
  • Writing

Do you find the content here on ComeauSoftware.com helpful?

Would you like to support the creation of more content like this?

©2023 Comeau Software Solutions | Theme by SuperbThemes