Sometimes we have scenarios where we want to change a record, in ways that might cause it to “shift” its logical position within a dataset, or maybe even disappear. To take an example think of dismissing a notation. To make…
Custom control collection – Creating and passing collections
If you have worked with Access for a while, you have probably at one point or another tried to loop through the controls collection on a form, like the below example:
|
1 2 3 4 5 6 |
Dim ctrl As Control For Each ctrl In Me.Controls If ctrl.ControlType = acTextBox Then 'do something End If Next |
And as such, you are already aware that…
Restoring popup to same position
Over the years I have many times tried to add the functionality of restoring a popup to the same location/size in which it was closed. But so far this always came with a risk with multi monitor setup. Say a…
Prevent click event from firing twice on doubleclick
I had an issue today where I kept getting error reports from a user. The procedure in question exports a file, and the error report kept saying the file was busy. I told him he couldn’t do a “fresh” export…
Customized zoombox
#December 11th, 2017: Version 1.1: Fixed typo in download Have you ever worked with the built in zoombox in access? Now the concept behind it is great. It allows for you (and users) to zoom in on the contents of…
RIP Access WEB apps, Long live the Access Desktop
If you have been at all involved with Access web apps, you might have noticed that there has been no development for a while. After several attempts from Microsoft at making a RAD (Rapid Application Development) easy-to-use development platform for…
Access error: Right Click Menu stays on screen
If you have recently updated your office, and you are on version you might have noticed a peculiar graphical issue. Suddenly when using a right click menu, sometimes the menu won’t disappear after you are done with the menu. This…
Meet the Access gurus – Become inspired
A few weeks ago I mentioned that Karl Donaubauer was trying to gauge whether there was enough interest, for him to host an english speaking version of his very popular german speaking Access conference. And thankfully enough people signed up,…
Saved by the backup – Do you have a backup plan in place?
As per usual, I was working in my database and had modified a form and module, as well as removed a module I no longer needed. I accidentally hid MZ tools “add Line numbers” function, which proceeded to add line…
Access Developers Conference in Vienna
Karl Donaubauer, who has been an Access MVP for 19 consecutive years, and have organized dozens of german conferences in both Access and .Net have decided to try to gather momentum for an english speaking conference in Vienna this spring,…
Recent Comments