Peter Vogel looks at some of the general issues around creating SQL queries that run quickly.

Peter Vogel looks at some of the general issues around creating SQL queries that run quickly.

vb123.com now rocks on the Ipad. Find the safari address and some pictures

Dennis Schumaker shows how to create reports that make sense to your users, along with the code to implement those reports within a set of standards.

Dennis Schumaker shows how to create reports that make sense to your users, along with the code to implement those reports within a set of standards.

When Peter wrote this column, he said that speeding up a database was his most lucrative consulting project task. Off course he always went for the easy target, too much data was being retrieved. But its not that easy. Have a read...

When Peter wrote this column, he said that speeding up a database was his most lucrative consulting project task. Off course he always went for the easy target, too much data was being retrieved. But its not that easy. Have a read...

In this article, Rickard Olsson shows how to compare rows in SQL by loading the desired data into two tables for easy comparison. In fact, he shows two different methods and tries to figure out which method will give the best performance.

In this article, Rickard Olsson shows how to compare rows in SQL by loading the desired data into two tables for easy comparison. In fact, he shows two different methods and tries to figure out which method will give the best performance.

If object-oriented development seems foreign to you, it shouldn't. All forms are defined in class modules, and all executing forms are objects. Garry Robinson shows how to take advantage of this to create classy forms.

If object-oriented development seems foreign to you, it shouldn't. All forms are defined in class modules, and all executing forms are objects. Garry Robinson shows how to take advantage of this to create classy forms.

Doug Steele looks at problems with handling dates - like inputting regional dates and guiding you to the reliable VBA date functions

Doug Steele looks at problems with handling dates - like inputting regional dates and guiding you to the reliable VBA date functions

Many moons ago, I graduated with a Post Graduate degree in Land Surveying. In those days, HP made the most fantastic calculators with reverse polish logic and brilliantly responsive buttons, computers cost $500,000 and were less powerful than an Ipod and I wrote my first program using cards that I marked up with a pencil (there was no keyboard). When I returned to university to undertake a Masters degree, a program appeared on the scene that would draw three dimensional pictures if you managed to arrange the information that the program liked to read. That was my thesis, organizing and displaying three dimensional data on $50,000 plotters and even taking pictures of screens to make into a movie. I learned that programming drawings and managing spatial data was very tricky. Which brings me to an early series of articles by David Saville on programming spatial data. If you do nothing else with this article, have a look at the code relating to the user data

Many moons ago, I graduated with a Post Graduate degree in Land Surveying. In those days, HP made the most fantastic calculators with reverse polish logic and brilliantly responsive buttons, computers cost $500,000 and were less powerful than an Ipod and I wrote my first program using cards that I marked up with a pencil (there was no keyboard). When I returned to university to undertake a Masters degree, a program appeared on the scene that would draw three dimensional pictures if you managed to arrange the information that the program liked to read. That was my thesis, organizing and displaying three dimensional data on $50,000 plotters and even taking pictures of screens to make into a movie. I learned that programming drawings and managing spatial data was very tricky. Which brings me to an early series of articles by David Saville on programming spatial data. If you do nothing else with this article, have a look at the code relating to the user data

This month, Doug Steele continues to show how you can gather data from unexpected places. In this article, he gets URLs from the Internet and a file of exported Opera bookmarks.

This month, Doug Steele continues to show how you can gather data from unexpected places. In this article, he gets URLs from the Internet and a file of exported Opera bookmarks.

Peter Vogel discusses setting the RecordSource property of a subform dynamically to improve an application's performance. He also answers some thorny questions about using ADO to update a view (you can't)

Russell Sinclair talks about optional parameters in SQL Server stored procedures, and how you can use them to do advanced searching of data.

Web Services. What is it? Do you care? Does it matter within Access? Peter Vogel answers these questions and more.