Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
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...
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...
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...
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...
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...
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...
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...
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...
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...
Form filtering using unbound text boxes continued
I started using the SDOpenAI plugin to write a class that could take multiple form control input values and create a string for a filter output for a form. It did a simple and respectable job in accomplishing my task, but as I started implementing it, I started...
Basic Filtering with form text boxes
There's tons of good articles out there on this. Just a couple of notes, I had a customer asking me about filtering a subform in a datasheet view. They were using Ctrl-F to bring up the Access find box which they were lamenting was not set to partial content by...
CDO email using a queue and emailing from one server
I have a couple clients now who had emails they wanted to either send out on a scheduled basis, like every Thursday, and/or when certain events occurred, like importing a certain type of file with certain types of part numbers, or a po is updated and causes a project...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994