Access JumpStart 2.0 | Email Archive
A Rapid Development Framework for Microsoft Access
Email Archive
Version numbers with SVN vs Git
Right now I'm recreating my strategy on versioning. My current process was to: Make sure the updated files in my working copy are committed to the SVN repository. Import a temp file using OASIS-SVN Update Process which is configured to kick off a process to update the...
VCS plugin usage and Access Form compilation gotchas
I didn't make tons of progress on my Access AI setup yesterday and today other than I started to transition one project fully to Git, the Version Control System plugin, and utilizing cursor. I'm not too far in yet, but I set up a page on my internal Sharepoint site to...
Moving to an AI based Access workflow
Lots of decisions to make in this new AI world and things are still emerging. My current direction has been to move to a new IDE and away from the VBE environment for most coding tasks. I started with Visual Studio Code or VS Code (Not to be confused with plain old...
Quoting Access projects
Lately I've been trying to transition to a quoting model for my work. It's been somewhat difficult mainly because I am tenative with deciding on quoted prices. I want to make sure I'm going to be able to be profitable doing it. I have 3 projects in the works right...
A few quick VBA tips for better development and deployment of your Access App
I didn't end up working on anything Access today, but I thought I'd throw some thoughts at you on programming in Access VBA: Always set the Option Explicit statement at the top of every module. There's an Access setting to always include it when creating new modules,...
Reminder: You can’t link linked Access file tables
Somehow I keep forgetting this. I keep thinking that at some time in the past I was able to link Database C to the linked tables in Database B which were linked to Database A. Why would this be helpful? My use case would be for my database table separation into...
Sharing the load – an exercise in splitting Access Files
I've decided that I'm not going to do this at the moment due to time constraints and other important features needing to be added to the database, but here's what I'll do eventually. I have one mammoth import database with one table for a file list and three more...
Simplifying Complex File Importing rules
Tracking down problems in your code can be a bear, especially when it complex and handling multiple situations. For example, today I was trouble shooting an import file that was not importing properly. I've so far tracked it down to the logic that determines whether...
Adding screen only buttons to a report for printing and adjusting report behavior as a modal dialog
Today I was working on a file importer in Access again for my customer. This importer is using the technique of throwing an error as discussed in my previous message. My next task was to display a report if the file being imported raised the error and allow the...
Handling Application level errors in Access VBA
I have a condition that to the application owners of an Access app is an error condition. If they try to import a parts file and the part pricing isn't in the part pricing table already, it should stop the import and tell the user to add the pricing information before...
Need a jumpstart, and crazy queries
I definitely need an Access jumpStart! Haha. Just a word about realigning priorities. I've really been re-vamping my internal business structure and schedule. While I was figuring things out, I have been away from writing, but I think I'm ready to come back now, so my...
New Year, new opportunities. Let’s go!
2026 has arrived! Wow, I never got used to it being 2025. So here we are at the beginning of a new year which many people view as a new start or the beginning of a new cycle. For me, it's important to review my goals from the prior year. What did I accomplish? What...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994