Datasheet Design Configuration

Overview The datasheet view in Microsoft Access offers a range of features and capabilities that empower users to manage and analyze their data efficiently. Its familiarity, flexibility, and integration with other Office applications make it a valuable tool for various data-related tasks.   Eas [...]

2024-02-16T15:08:34-06:00February 16th, 2024|

Access With SQL Server Meeting is back this January 9th!

Join me this Tuesday January 9th, 2023 at 6:30 PM as we start exploring tools that will help you be more productive. Here are the details: Join us this Tuesday, January 9th for the Access SQL Server Meeting! Session Title: Tools to help you automate Access coding – with FMS founder Luke Chung This m [...]

2024-01-08T09:06:11-06:00January 8th, 2024|

Join me Tuesday December 12th at 6:30 PM Central – MZ Tools

Join me this Tuesday December 12th, 2023 at 6:30 PM as we start exploring tools that will help you be more productive. Here are the details: https://accessusergroups.org/sql-server-with-access/event/automating-access-programming-leveraging-mz-tools/ [...]

2023-12-10T09:31:11-06:00December 9th, 2023|

Bringing the IT Impact Family Together: A Dream Come True

For over two decades, far before the COVID crisis, IT Impact has thrived as a remote company, embracing the dynamic world of technology and innovation. Virtual meetings became the norm, connecting team members from various corners of the globe. But deep down, one goal has always burned brightly in o [...]

2023-11-02T10:54:30-05:00October 27th, 2023|

Managing Microsoft Access Autonumber Fields

  Yeah, I know what you’re thinking... "Why do autonumber fields need to be managed? Don’t they manage themselves?" Well, yes, autonumber fields are pretty much self-managing, but there are times when you, as a database manager, may need to repair a table with an autonumber field and you’re sca [...]

2023-07-26T09:23:59-05:00July 26th, 2023|

The State of Access in 2023

The future of Microsoft Access in 2023?  Earlier this year I was in Redmond, Washington, to participate in the MVP Summit, where I heard a lot about AI and Office and met with the Access team (it’s one of the best benefits to being an Access MVP). Although I can’t share much of what we discussed, I’ [...]

2023-06-06T10:34:48-05:00June 5th, 2023|

The Highly Popular Yet Confounding Access Datasheet: Bug Fixed!

Over the years (almost two decades), there was (it has been fixed now in the latest versions) a glitch in the Access Datasheet Wizard that created a confounding condition that led many to take to the help forums to find a solution. You see, one of my favorite features of the datasheet is using the c [...]

2023-05-15T11:27:46-05:00May 12th, 2023|

Understanding how Access deletes records

It is common to run across questions about how Access handle deletions, particularly from the VBA code. The Access form provides 3 events around the deletions but they are easily misunderstood. I attribute this to how the events are presented in the Property Sheet's Events tab: If all we did was jus [...]

2023-05-03T16:34:59-05:00May 2nd, 2023|

Can ChatGPT write VBA code? How about SQL Queries? Yes! But…

I've been playing with ChatGPT for a while now and mark me impressed with its capabilities. One of the first things I did was ask it to create a VBA function that calculates the first of the month: A couple of points on the code above: I never named the function yet the AI used a great name: FirstOf [...]

2023-01-24T17:32:01-06:00January 22nd, 2023|

Updating your SQL Drivers can be a pain, unless you do this

It seams Microsoft is releasing new drivers every few months now, trying to keep pace with the trove of new SQL Server and Azure features that come out with every new version. The drivers do double work, both with the product you can install locally, and the Azure service in the cloud. Why you shoul [...]

2022-12-04T11:59:26-06:00December 4th, 2022|
Go to Top