by Jonathan Halder | Aug 5, 2024 | Blogging
This is one reason why I don’t like giving time estimates to customers. You know the drill: Customer: So how long is it going to take you to do X? Me: Uh, when do you want it? Customer: Yesterday. Me: Not that fast… how about on Friday? My decision for...
by Jonathan Halder | Aug 1, 2024 | MS Access, Versioning
I use an SVN server to store versioning information for all my Access work that I do. A shout out to the OASISsvn Access Add In and TortoiseSVN for Windows which are two pieces of software I use daily in my Access versioning work. How it saved by butt today: I had a...
by Jonathan Halder | Jul 30, 2024 | MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding
Yesterday, I was talking about the BeforeUpdate form event and BeforeUpdate Access control event as ways I was looking at triggering a validation function and then canceling the event so the update would not occur. A reader wrote in to mention usage of the Change...
by Jonathan Halder | Jul 29, 2024 | MS Access, MS Access Forms, MS Access VBA Coding
It’s easy to get burned when trying to set up custom validations for Access fields and enforcing them while the form is being filled out. I have a form with the following fields (of the type): Vendor Name (string) Is Vendor Active (checkbox) Is On PO form...
by Jonathan Halder | Jul 26, 2024 | MS Access, MS Access VBA Coding
Sometimes you can get runtime errors when you are trying to assign the value of a control to some VBA object. For example, consider this statement: TempVars!NewTempVar = Form_orders.order_id What we are trying to do is set the NewTempVar in the TempVars system...
