Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Stay on target…
If you're a Star Wars fan you might remember one of the Y-wing pilots flying through the Death Star trench, flying towards the tiny little vent he needs to shoot his torpedo into in order to take advantage of a tiny flaw that would mean the destruction of the massive...
Working in an Agile way…
Providing feedback and getting feedback is SOOO important. My customers give me an idea of what they want. It's often in the form of some behavior they want from a form or data modeling on a report. It's usually pretty minimal in content with an assumption I already...
Guiding principles
When I get to work on other people's databases (or my own for that matter) I have a couple of main principles I use to test my solution. I don't consider it done until it passes these 2 tests: My first principle is to simplify the users' job. The second is to...
Poking around to find new customers
Ok, so I'm not a professional marketer at all and this is NOT a marketing list. I don't think 🙂 Tell me if you think I'm wrong. Anyway, I am trying out social networking on LinkedIn and Alignable to see if I can find some business owners or department heads who are...
Access file backends with multiple users – locking
As an overview, a big issue with multiple users is editing the same data and tables. The issue needs to be addressed differently depending on what backend you are accessing the data from. Today we'll start the discussion with Access file backends. Access files handle...
Manual test driven development
Ok, so this really doesn't qualify as test driven development because a key of that discipline is to automate your tests. That means you actually would have a set of functions that would automatically test various things as you create them and you leave those tests in...
Copying and modifying code / forms / objects
Especially when you begin creating, it's often easy to think that copying and modifying objects to do the new thing that you're being asked to do is a good way to go. It's fast and builds on previous code and concepts, but often can easily result in nasty hacks that...
Setting up an automated Access App upgrade strategy
Today I was considering how best to setup automated upgrades for a customer for when I deploy a new version of their Access suite. I say suite because it is together about 9 Access programs that all get installed using an install file that I create using SSE Install...
Microsoft Access with multiple users
This is an entire planet to explore in and of itself. There are multiple layers of sharing when it comes to creating Access databases and applications with multiple users. Although fraught with land mines, users can use the same Access front end at the same time. This...
Dealing with complex SQL queries
I find myself annoyed with my younger self as I slough through multiple views and queries to slightly change some things so that I can get a similar result set with slightly different customer requirements. Simply put, in this case, the main issue is that I have 2...
Two Form Filtering strategies
Today I updated a form and added a new filter textbox to it to allow the customer to specify part of a part number and filter a list of CSV files that contain that part number. It's actually already processed these files and the data for all part numbers is in a long...
Sometimes one makes dumb mistakes 😛
What did I do today? I have a complex order form I built according to customer specs. They have several different scenarios and ways in which they can open an order in the form and I did not build the form so that it is capable of opening multiple orders at once. In...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994
info@halderconsulting.com