Search results

Please join us for our Monthly Chapter Presentation April 4, 2024, at 6:30PM Pacific (UTC -8) Kent Gorrell shares a new and intriguing method of creating audit tables in SQL Server. The best part is that no SQL Server triggers are involved and once it’s in place, the audit table automatically...

Please join us for our Monthly Chapter Presentation Thursday, March 7, 2024, at 6:30PM Pacific (UTC -8) In a world that is increasingly connected via the internet, sometimes the best way to accomplish a task is still to use the power of VBA and some long-familiar techniques for data sharing...

Please join us for our Monthly Chapter Presentation February 1, 2024, at 6:30PM Pacific (UTC -8) Check out WorldTimebuddy to determine start time for your location. This presentation takes our discussion of classes and subclasses to the next level: a Framework or Library. Join John and bring...

Please join us for our Monthly Chapter Presentation January 4th, 2024, at 6:30PM Pacific (UTC -8) Kent will draw on his decades of experience providing solutions for his clients to share his insights into the Power of Sub Classes. Here’s an outline of what you can expect, in an Overview, a...

Please join us for our Monthly Chapter Presentation , December 7, 2023 at 6:30PM Pacific (UTC -8) Word is a perfect compliment to Access; it can be automated using VBA. Word document properties give you a powerful way to substitute data that’s stored in Access. However, the user interface to...

Please join us for our Monthly Chapter Presentation , November 2nd, 2023 at 6:30PM Pacific (UTC -7) Daylight Savings Time changes are beginning. John Colby will give us a more in-depth look at how he implements the classes introduced in his September presentation. In Part I, John introduced...

Why I do not trust ChatGPT

Can you display and edit properly normalized data in a form which resembles a spreadsheet? Although it sounds impossible, it can be done with the right technique. Pat Hartman shares her method with us. She will show us the sample database containing two examples (using the same technique) of...

Event Driven Programming using classes can expand the power of Access applications. Long-time Access developer and author John Colby will demonstrate and explain using classes in your own applications. Events are the very essence of MS Windows and every application running on it. Think about...

Please join us on Thursday, August 3rd for a look at Global Error Handlers With Tom van Stiphout and Kim Young. Tom van Stiphout and Kim Young explain and demonstrate the Global Error Handler implemented in Northwind Developer Edition Global Error Handling is one of the modern features...

If you've ever wondered what a hybrid app could look like, this presentation might answer some of your questions. The new Northwind 2.0 Access Developer Edition template uses inventory management based on the method Allen Browne described in 2010. This method requires regular physical stock...

Greg Regan shares lessons he learned from a decades long career in Access development. Unfortunately, many functional MS Access solutions look terrible, and that can mean potential clients are reluctant to invest in an Access solution. The previous 10 or 15 years of great web design and phone...

Maintaining Data Integrity is crucial to the success of a data migration. Migrating your data from Access to a server-based database like SQL Server is only part of the process. Perhaps even more important than physically moving the data, you have to pay close attention to maintaining its...

Please join us for our Monthly Chapter Presentation on May 4th, at 6:30PM Pacific (UTC -8) (Please verify your Time Zone offset.) What do you do when you can’t find third-party software tools to accomplish tasks you need to get done quickly and without hassle? Eric Blomquist decided to just...

Thank you to everyone who has downloaded and tried the new "NW 2.0" showcase templates! Your feedback is wonderful, so please keep it coming. We're aware of one problem affecting a beta channel build that was released to a limited audience after we delivered the templates to Microsoft for...

Former Access MVPs Tom Wickerath and George Hepworth will discussion preparing for a migration from Access to SQL Server and demonstrate two tools for doing it. The Access Pacific AUG Monthly Chapter meeting is on April 6th, at 6:30PM Pacific (UTC -8) (Please verify your Time Zone offset for...

Please join us for our Monthly Chapter Presentation on March 2nd, at 6:30PM Pacific (UTC -8) You'll find the link for our Zoom meeting on our web page. Pat created a database to help people to understand how and why to use the Form’s BeforeUpdate event to validate data before it can be saved...

Power Apps for Access Shopping List Demo I promise to speak English, but I can't vouch for the rest of the cast and crew.

January, 2023 Access Pacific Virtual User Group Presentation Juanjo Luna, the newest MS Access MVP demonstrates using REST/APIs in Access VBA to manage data in three online platforms: WooCommerce for eCommerce applications Jira for Project Management Trello for Project Management Using...

One of the biggest bottlenecks in data entry is the need to add multiple items one-at-a-time to a process or order. Kent Gorrell explains how he speeds that up for his clients. Kent Gorrell, Consultant, Business Analyst, SQL Server and MS Access Developer at Osel Solutions in Brisbane...