ASP Table Wizard generates an Active Server Page displaying fields you select from an Access database in a nicely formatted html table.
You need VB6 with service pack 3 and DAO 3.6 or higher on your machine for the wizard to run.
UI Details
----------
Run tablewiz.exe.
Point to an existing Access database.
Click Next.
If the database is password protected, enter the password and click OK.
Select a table or query.
Click Next.
Select the fields you want to appear on the html form.
Click Next.
If you want to display a table border (not recommended because it looks awful (but some people are still used to it)) turn on the 'Show Table Border' checkbox.
If you want to alternate the color of the table rows (recommended because it looks very cool) turn on the 'Alternate Table Row Color' checkbox.
If you want to numbers and dates to appear right aligned in the table turn on the 'Right Align Numbers And Dates' checkbox.
Verify your selections.
Click Finished.
A new window will open containing the VBScript code generated by the wizard. Copy this code to the clipboard and paste it into your editor or click the Save button to save the code to a file.
Table Wizard now uses tablewiz.ini to remember the last 10 databases that were used. The first time close the wizard after successfully selecting a database it will create tablewiz.ini in the application folder. I chose not to use the registry to store this data since I don't have an install program and there's no clean way to remove the registry settings if the program is removed.
Code Details
------------
Scan the code for any TODO: comments.
Hints
-----
You can put a shortcut to tablewiz.exe in your SendTo folder then right-click on an Access database and send that database to the wizard.
You can drag and drop an Access database from Explorer to the wizard.
ASP Table Wizard History
------------------------
Build 1.00.0002 (07/24/98) Initial release
Build 1.00.0003 (07/26/98) Modified Save dialog to remember last saved directory. Thanks Ray!
Build 1.00.0004 (07/27/98) Fix to bracket query/table names that contain spaces.
Build 1.00.0006 (07/28/98) Added database drop down list to first panel. Using tablewiz.ini
the wizard remembers the last 10 databases used.
Build 1.00.0007 (09/06/99) Modifed to work with Access 2000 databases.
Build 1.00.0008 (03/30/00) Modifed to work with Windows 2000.