Author: TheSmileyCoder

One of the perhaps lesser known properties of the access form is the navigation caption. This property controls what you see in the bottom left corner of your form (Provided you have not turned off navigation buttons). If you leave …

Navigation Caption Read More »

If you have used VBA for more than just recording Macros in Excel, you probably know about Debug.Print, so I won’t go into the usual stuff, but rather tell you about some of the lesser known features of Debug.Print. A) …

Debug.Print “The Fine Print” Read More »

Tagged with: , ,

Once again Danial Polak has lined up a great collection of speakers for his Developers Day in Amsterdam, on the 14th of September Come join myself and other international speakers from both Europe and the US for a full day …

Netherlands Access Developers Day in Amsterdam Read More »

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 …

requery_with_position_return Read More »

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:

And as such, you are already aware that …

Custom control collection – Creating and passing collections Read More »

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 …

Restoring popup to same position Read More »

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 …

Prevent click event from firing twice on doubleclick Read More »

#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 …

Customized zoombox Read More »

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 …

RIP Access WEB apps, Long live the Access Desktop Read More »

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 …

Access error: Right Click Menu stays on screen Read More »