Category Archives: VBA
Forms, Sorting Reports, and Dating Errors
This month, Andy Baron addresses a variety of issues, including several tips related to forms, a look at how to dynamically sort reports, information on an undocumented feature of Access, and a discussion of how VBA handles certain date/time calculations. … Continue reading
Everything About Using Parameters from Code
Mike Gunderloy untangles the problem of using parameter queries from DAO or ADO code. I created a parameter query that gets information from a form, and it works fine when I open the query from the database container. Now I … Continue reading
Embedded quotes in SQL statements
This month, Doug Steele passes on feedback he’s received from readers about past columns. Along the way, he shows how different priorities cause different programmers to come up with different solutions for the same problem. See the rest of the … Continue reading
Doug Steele Needs a Date
In Access Answers, Doug Steele addresses commonly asked questions from Access developers. This month, he looks at problems dealing with date values. I’m running into problems using dates, especially among users with varying regional settings. Users enter a date in … Continue reading
Did Someone Say Holiday
In your September 2004 column (“Working All Day”), you talked about requiring a table of holidays in order to be able to include them in addition to weekends when calculating working days. Is there a way to automate creating such … Continue reading
