Category Archives: Old Material
Managing Margins Of Text Box and Label Controls
This month, Chris Weber talks about four TextBox and label formatting properties that were introduced in Access 2000–and some unexpected side effects of using them. In Access 2000, the Access development team at Microsoft introduced four new formatting properties for … Continue reading
It’s a Grand Life if You Don’t Weaken
I’ve discovered that the essential item for an aspiring computer consultant isn’t a laptop, or a manual, or even expertise. The key item is a good suitcase. I don’t know if it’s everybody in this business or just me, but … Continue reading
Improving on VBA with Transact-SQL
In this article, Burton Roberts demonstrates some of the advantages of writing code for SQL Server stored procedures and functions instead of VBA functions and subs. T-SQL, the language used in stored procedures and throughout SQL Server, is very similar … Continue reading
Effective SQL for Scheduling
Peter Vogel describes how a combination of SQL and Access generated a solution for a scheduling application. In the process, this article describes how a set-based approach to the problem will let you find the most effective SQL solution. On … Continue reading
Editorial: The Future of Jet?
I get asked quite frequently (just last week, for instance) if SQL Server will replace Access. As I’ve discussed here before, the question is wrong-headed: Access is a tool for creating database applications; SQL Server is just a database. A … Continue reading
