by Steven Halder | Dec 5, 2022 | MS Access, MS Access Features, MS Access VBA Coding
You can control how your project is compiled. Have one “source base” that you use for multiple purposes, environments, or in multiple “modes” of operation. You can use Microsoft defined Compiler Constants and you can define your own....
by Steven Halder | Dec 5, 2022 | MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding
The Access Web Browser Control is not a Web Browser Object, but does contain one. To access the internal workings of the control with VBA code, it is most convenient to dimension and use variables as follows, where the name of the control is “MyWebBrowserControl”: DIM...
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 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...
by Jonathan Halder | Aug 27, 2020 | MS Access Features
Start by creating a blank Access file anywhere (this will be your library). The only restriction here is that it should be accessible as a file either on the same computer or a shared drive of another computer on the same network as the Access app that will reference...
