by Steven Halder | Jan 31, 2022 | MS Access, MS Access Features, MS Access VBA Coding
So you’re updating some VBA code you wrote a while back… Now what is the Error Processing section doing? What do those Error Numbers mean? I shoulda’ written some comments! Well you can just look up each of those error descriptions quickly by using...
by Steven Halder | Jan 27, 2022 | MS Access, MS Access VBA Coding
So your Access application crashed and user feedback is not specific enough to diagnose the problem? It sure would be nice if your application VBA code could send you an email with all the error details! Well, The Smiley Coder has written and published just such a...
by Jonathan Halder | Jun 18, 2021 | MS Access, MS Access Forms, MS Access Queries
I recently experienced a frustrating issue that had me scratching my head for a while. I had a PO form with a Line Item subform and I could edit lines and when I tried to delete a line it was removed from the subform. BUT… If I closed and reopened the same PO...
by Jonathan Halder | Jun 4, 2021 | MS Access, MS Access Forms, MS Access Reports
So I had a form that opened a report using a function in another module using DoCmd.OpenReport. This worked fine and the report popped open and appeared to be the active object on the screen. However, it was not. The behavior this caused was that when I clicked on the...
by Jonathan Halder | Jun 3, 2021 | MS Access, MS Access Features, MS Access Forms
Recently, a customer requested that all changes to their form be logged and added to the email that is sent to the project manager associated with the project assigned to the form. I found some code to walk a form during the BeforeUpdate routine and look for and...
by Jonathan Halder | Nov 30, 2020 | MS Access, MS Access Features, MS Access Forms
As you mention, you could determine the available screen space. You are going to have a somewhat complex job because you will have to set the top and left of every visible control on the screen. That is one way of doing it that will work. The other way...
