O'Reilly logo

Microsoft® Office Access 2003 Step by Step by Online Training Solutions Inc.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using VBA to Create a Web Page

Exporting an Access object to static Web pages is quick and easy, but if you want to manipulate the data as you create the static pages, the export process won’t be of much use. A better way is to create a module containing VBA code that manipulates the data.

As an example, suppose The Garden Company wants to use data in the Customers table to create a set of 26 Web pages, one for each letter of the alphabet. Each page will list the customers whose last names start with the correlating letter and will contain links to all the other pages in the set. All the legwork for setting up the pages can be done with VBA code.

The sample GardenCo database for this exercise includes HTML_final, a finished and fully commented version ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required