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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment