Access Help

Create Delete and Update Audit Tables in Microsoft SQL Server

Create Delete and Update Audit Tables in Microsoft SQL Server This is a modification to an earlier tip I wrote, whereas this code will only record delete changes, my earlier article will record delete and update changes to the data. I found code online by Brett Kaiser and I modified it for my purpos [...]

2021-06-11T07:45:45-05:00June 15th, 2015|

How to Open Your MS Access Application Like a Custom Application

How to Open Your MS Access Application Like a Custom Application Level of Difficulty Easy Applies to MS Access Versions Access 2000+ Overview: Sometimes, when we create a full blown application, utility, or departmental tool, we only want to see the opening form pop up on the screen and leave the fu [...]

2021-06-11T07:54:05-05:00February 4th, 2015|

Microsoft Access User Group Webinars for November

Microsoft Access User Group Webinars for November We are happy to announce not one but four Access User Group (AUG) meetings this month. This is a wonderful opportunity open to novice and professional developers to learn new tricks. Each webinar is free and you don’t have to be a member to participa [...]

2021-06-11T07:56:09-05:00November 6th, 2014|

Chicago Event: Stored Procedures in MS Access

Juan Soto will be presenting next week at the Chicago Access User Group (CAUG). This is a great opportunity to network with other software developers and Access users, as well as a perfect venue to share tips, techniques, and ideas. Join CAUG’s kick-off meeting with Juan Soto, Microsoft Access MVP, [...]

2021-11-23T07:29:55-06:00September 18th, 2014|

Inno Setup – Create a Professional Installation for MS Access Solutions

Omar Rodriguez is a Programmer at IT Impact, Inc. with over 16 years of experience and a proven track record in design, development, and implementation of complex projects and high-performance solutions. We hope you enjoy his first post on the Access Experts blog, and feel free to contact him here o [...]

2016-02-03T00:50:18-06:00September 16th, 2014|

Access User Groups

The purpose of this group is to create virtual chapters throughout the world, from beginning user groups to advanced topics such as SQL Server. Chapters can be organized around a language, such as Spanish, a region, such as Spain or a topic of interest, such as Access functions. We hold monthly meet [...]

2014-07-14T22:52:49-05:00June 16th, 2014|

4 Features every Access program should have

When you do Access development work as long as we have, you start seeing trends and understanding on how users react to your work. Over the years we've developed some great features that make using Access in a business setting ideal. Queues Businesses deal with services or orders that go through sta [...]

2022-07-28T14:42:45-05:00May 28th, 2014|

4 Reasons Why Your Data is More Secure on the Web

Cloud Data Security As a recognized leader in cloud enabling Microsoft Access, sometimes our firm comes across clients who are reluctant to place their data online, oftentimes due to the many stories they hear regarding data breaches or hackers obtaining data. Despite these common perceptions, cloud [...]

2014-10-28T01:36:24-05:00May 20th, 2014|

Avoid the Groundhog Day Effect: Delay Loading Subforms in Access Part 2

We use subforms in Access a lot around here. Sometimes, we may have upwards of 5 or 6 subforms per form. Adding that many can be a real drag on performance if you're not careful. This is part one of two posts on the topic. Ben will talk about disabling the loading of subforms on startup in our next [...]

2014-11-11T03:01:19-06:00December 18th, 2013|

Whether to exists or not exists, that is the question…

This is second part of 2-part series on SQL clauses. Juan covered the IN() in the first part. We now turn to a close sibling, EXISTS clause. As Juan demonstrated, IN() can be useful for some situations where we want to match a subset of another table without necessarily changing the output due to jo [...]

2021-06-10T10:02:29-05:00October 2nd, 2013|
Go to Top