by Jonathan Halder | Apr 8, 2024 | MS Access, MS Access Forms, MS Access VBA Coding
The other day I was coding an Access Form which displays a file list to choose files to import into the database. I had created the following components: An Access Form named: ImportForm A Class Module to handle a full list of files available for importing and...
by Jonathan Halder | Apr 5, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
It’s time to add a new test: ‘@TestMethod(“Initialize”) Private Sub WhenThereIsAForm_ThenItCanBeAssigned() Dim testFormAuditor As FormAuditor Set testFormAuditor = New FormAuditor testFormAuditor.Init Forms(“TestForm”) End Sub This...
by Jonathan Halder | Apr 2, 2024 | MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
One of my clients was occasionally getting a 2455 error in Access: Run-time error ‘2455’: You entered an expression that has an invalid reference to the property Form/Report. What was happening in this case was that the user had minimized Access and then...
by Jonathan Halder | Mar 29, 2024 | MS Access, MS Access Features, MS Access Forms, MS Access Reports
I had generally used Subforms in Subform/Subreport controls as part of a standard form. I hadn’t even really thought too much about the fact that you could put report objects into a Subform/Subreport control. What pushed me in the direction of using a report in...
by Jonathan Halder | Feb 20, 2024 | MS Access, MS Access Features, MS Access Forms
Yesterday we discussed replacing the Access Splash Screen with your own custom bitmap. Today We will discuss how to launch the app without seeing the Access database window and just using your main form. The technique involves a few different Access settings and a...
by Jonathan Halder | Feb 2, 2024 | MS Access, MS Access Forms, MS Access VBA Coding, TDD
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...
