Access JumpStart 2.0 | Email Archive
A Rapid Development Framework for Microsoft Access
Email Archive
Customizing Access: Replace the splash screen
There are some nice little features of Access and some nice tutorials and articles out there to help launch an Access app without making it obvious to the user it is an Access app. The first one I'm going to discuss today is: Replacing the Access Splash Screen When...
Access JumpStart – The Documentation
I started a series on Access JumpStart yesterday with an overall summary of what we were trying to accomplish with it within our company and as a product. Internally we are currently using AJS version 2.1, and we are packaging it up now to update on our web site. For...
Access Programming – What I do and Why (Access JumpStart)
What is Access JumpStart? Thanks for asking. Access JumpStart is our collective work as a two man programming outfit to share common code for our apps across multiple clients, architectures, and configurations. Steve and I call it a framework. It originally was named...
TDD – 052 – Woohoo, refactoring success!
In the last email, I was considering a function that would do all the comparisons of the before and after values of the FieldChanges dictionary in the AuditEventDetails object and the Input dictionary I created. This would return a Boolean. It sounds good as I say it...
TDD – 051 – Now to refactor the test…
Quick question to my readers: If you know a good way of highlighting the code in an email I'd like to do that. I notice that my code in the email is not marking up properly whereas it looks better on the site itself. I'm using a WordPress feed and the Prismatic plugin...
TDD – 050 – Function refactor successful
Here we are, refactoring this function: Private Function SetFields_ChangeThem_ReturnDictionary(dctFieldName_arrStartAndEndVals As Dictionary) As Dictionary Dim testFormAuditor As FormAuditor Dim itm As Variant For Each itm In dctFieldName_arrStartAndEndVals...
TDD – 049 – Still refactoring the big change I wanted
As I continue to refactor the test, this time I am going to try to create the dictionary object I think I want to get back and pass that to a helper function which will change the fields to the before state, instantiate the FormAuditor class, run a single BeforeUpdate...
TDD – 048 – Refactoring too much (Don’t try this at home)
TDD is all about small changes and then testing and making sure things continue to run. I made the mistake yesterday of trying to refactor too much at once and I ended up leaving my system in an unrunnable state. Ideally, as you are developing, each change you make is...
TDD – 047 – Refactoring to make field changes simpler
Ok, so now why am I creating all these objects in my test? How about creating the objects I want to see returned and use those to run the test on the form and then see if it's the same objects I get back? I kinda feel like that is making the tests brittle because I'm...
TDD – 046 – Using ParamArray in VBA subs
We are in a refactor cycle, so it's time to look at my mess and see what I can do to clean it up a bit. I had to make a number of changes to the test in order to test multiple fields at once. It didn't work with my existing function which changed a single field and...
TDD – 045 – And with several more implementation details added, the test passes!
I am working on passing the test: WhenTwoTextFieldsChangeBeforeAndAfterValuesAreReturned. Right now it is getting a compile error in the FieldChanged function because in the loop over the controls I am trying to pass the variant Fld variable, which the function...
TDD – 044 – Fixing the test and adding the loop
This one is broken because I am not looping through the fields to get the correct object set up and I had hard coded the Dictionary entry with the index “TestText” Me - yesterday I am also seeing that my test isn't actually doing what I want. The test is using the...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994