This demo has been updated to use the SavePicture function in Access instead of all the previous Windows API calls. Using the code example that Saliq commented on I have introduced a function to convert a hBitmap to an IPicture object, therefore allowing use of the SavePicture function. This relative small change in function has [Read more...]
Here’s a simple demo to show how to detect the current network connected state. A developer required a method to determine whether the current user was accessing the database via LAN or VPN. I don’t know the reasons why this was wanted but anyway this code shows you how to do it! The solution basically [Read more...]
I’ve only just discovered an issue with the Dashboard demo, so just letting you know that there is a new fixed version. The problem was if you changed the number of steps in the demo then it wouldn’t place the needle in the correct position. This was due to the fact that I had neglected [Read more...]
Dashboard Class Sorry for the wait as I know this is the part you have been waiting for! I’m sure you’ve probably downloaded the demo by now and tried it out anyway. The Dashboard class relies heavily on the Needle class so please see Part 1 of this topic to familiarise yourself with it before [Read more...]
Here’s another database I did to help a fellow Access developer on LinkedIn. The question asked was “I would like to find an inexpensive needle gauge (like a speedometer) that can be used with Access 2007 to produce a dashboard application”. Well, I decided to have a play around with a standard Access Line control [Read more...]
Recently on LinkedIn I helped a fellow Access developer with a problem they had. They wanted to be able to save an image of a Google map to file without any user interaction. After trying to solve the problem using the url2bmp utility and failing another solution was required. There did not seem to be [Read more...]
This is my very first blog entry, congratulations to me. So bear with me while I get to grips with setting up my site. I intend posting a couple of articles very soon that I’m sure most Access developers will find very useful. But for those that can’t wait, please visit the Downloads page. These [Read more...]