Access Database VBA Detect Shift Key on Button Click
While working on a Time Logging database, I wanted to develop a simple way for the user to add a second entry without adding another button to the form. Let’s say that 99% of the time there will be just one entry, so having the extra button would get in the way of a clean look. Well, at least in my opinion. At the same time, I did not want to trouble the user by having them leave the input form. My solution was to enable the user to hold down the shift key, which would… Continue reading
Updating a Website from Access using VBA and FTP
I have a few personal databases that I’ve developed in which I export files and upload to my website. When I was using my ISP’s free hosting this was never an issue as I could just select the FTP site saved in My Computer. Well time has past and my hosting needs changed and I wound up with GoDaddy hosting. I was soon faced with the reality that a real hosting service was quite different from what I was accustomed to with my free ISP’s web space. My major problem was my databases were no… Continue reading
Access 2010: The Missing Manual
For anyone who has updated from an older version of Microsoft Access and have been overwhelmed by the Office ribbons and new features there is a great book that covers these changes starting right off in the Introduction. The Access 2010: The Missing Manual is a great read for anyone wanting to get started in Access database development.
What I really like about this book is the author, Matthew MacDonald, doesn’t take the typical teaching approach of showing how to modify the Northwind database as is typical with other Access books. Instead the book focuses on… Continue reading
Microsoft Access 2010 SP1 VBE7.dll Crash Hotfix
For months Microsoft has know and have been working on a fix to a major issue that would immediately crash Access 2010 . There was a lively discussion started in July on Microsoft’s Answers site.
For months the band aid solution was to decompile the database in question.
- C:\dbwithissue.accdb /decompile
This worked just fine, but it was like playing Russian Roulette with your databases. You could go a day or so without any issue, but the crashes would return without notice.
It was determined the issue was a result of the VBE7.dll included with the SP1 update.… Continue reading
Random Contact Generator – Instantly Create Fake Mailing Lists
Have you ever had a need for a fake mailing list or contacts to populate a database table during development of your website or database project? I know I do not like to use real names and addresses during development so I developed the Random Contact Generator (RCG), a simple application to do the work for me.
RCG will return First Name, Middle Initial, Last Name, Address, City, State, Zip Code, Phone Number and email address.
RCG offers option to generate logical City State and Zip Code combinations that exist in the United States (Tampa, FL 33601) or… Continue reading
