Category Archives: VBA
Working All Day – Weekends
This month, Doug Steele looks at calculating working days. DateDiff computes how many days there are between two dates, but I want to only consider working days. Is there an easy way to ignore Saturdays and Sundays? There are a … Continue reading
When DateAdd Doesn’t
Chris Weber shows you how DateAdd can give you results that you may not be expecting–and then provides the routine that will give you what you want. Along the way he introduces you to the kind of problems that crop … Continue reading
Using FTP from Access Applications
We live in a “connected” world–almost every system has to exchange data with other systems. One of the oldest and most widespread communication protocols is FTP. In this article, Bogdan Zamfir shows how you can incorporate FTP access into your … Continue reading
Using Dynamic External Event Procedures
Reusable code libraries let you deploy bullet-proof applications. Shamil shows you how to create a library of objects (with inheritance) that you can use to process Form events. All you have to do is use the WithEvents keyword and Access … Continue reading
User Preferences, Toggles, and Rocket Science
Maybe it isn’t rocket science, but maintaining user preferences will make your applications more appealing. Follow along as Danny Lesandrini demonstrates how you can maintain a variety of user-defined options. I’m not a rocket scientist, and fortunately, I don’t need … Continue reading