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

Category: Microsoft Access

Helping Users Work With Subforms in Microsoft Access

Posted on March 19, 2019February 14, 2023 by Andrew Comeau

Creating an Access application for other people means anticipating how the users are going to interact with your program. Without clear direction from the program or you, users can be easily confused by even simple things like the order in which data is to be entered. One of the basic tools in Access is the…

Read more

How to Programmatically Relink Tables in Microsoft Access / VBA

Posted on January 15, 2019April 30, 2023 by Andrew Comeau

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 Create a Dynamic Search Filter on a Microsoft Access Form

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

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 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

What is Referential Integrity?

Posted on November 18, 2018February 18, 2023 by Andrew Comeau

One of the fundamental differences between an Excel spreadsheet and a Microsoft Access or SQL Server database is the database’s ability to group data by subject into tables and create links between that information.  This type of organization enables the user to store large amounts of data and retrieve specific information quickly by writing queries that…

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

Using Visual Studio to Manage Your Data

Posted on December 23, 2014February 14, 2023 by Andrew Comeau

(This article was updated in August 2018 for use with Visual Studio 2017.) Moving Beyond Microsoft Access I’ve written a lot about Microsoft Access over the years and still believe it’s a great training ground for people who want to learn to design database applications. Its user-friendly interface provides an easy learning curve and introduction…

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
  • Previous
  • 1
  • 2
  • 3
  • 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


DYMO 1755120 LabelWriter 4XL Thermal Label Printer
Quickly prints XL shipping labels up to 4" wide. Over 60 professional templates from popular shipping platforms.

Dymo
  • 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