Access Help

Create Delete and Update Audit Tables in 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 purposes, with a mind to other Access developers I made some changes [...]

Create Delete and Update Audit Tables in SQL Server2015-10-26T19:43:02+00:00

How to Open your MS Access Application like a Custom Software 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 full MS Access application window at the bottom of the toolbar. In [...]

How to Open your MS Access Application like a Custom Software Application2015-02-05T00:21:11+00:00

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 participate. Interested in joining one of our virtual AUGs? [...]

Access User Group Webinars for November2014-11-19T23:06:01+00:00

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, [...]

Chicago Event: Stored Procedures in MS Access2014-09-20T00:33:24+00:00

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 [...]

Inno Setup – Create a Professional Installation for MS Access Solutions2016-02-03T00:50:18+00:00

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 [...]

Access User Groups2014-07-14T22:52:49+00:00

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 [...]

4 Reasons Why Your Data is More Secure on the Web2014-10-28T01:36:24+00:00

Delay Loading Subforms in Access Part 1

In part one, Juan talked about the sequence of events fired when loading a form with a number of subforms in Access and how one can reduce the cascading effects of events being refired due to operations performed during the load. We will talk about how we can delay loading the subforms. By putting o [...]

Delay Loading Subforms in Access Part 12014-11-11T03:01:27+00:00

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 [...]

Avoid the Groundhog Day Effect: Delay Loading Subforms in Access Part 22014-11-11T03:01:19+00:00

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 [...]

Whether to exists or not exists, that is the question…2018-02-19T18:36:01+00:00

Are you IN or are you out? (Not IN)

This is a part one of two-part on how you can make your queries much more powerful. In first part, we look at whether we're in or not. Part two can be found here. The IN clause is a great tool to have in your arsenal, it can allow your forms to be editable or filter forms using . What is the IN clau [...]

Are you IN or are you out? (Not IN)2018-02-19T18:35:12+00:00
Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.