Home	Excel	Access
| Feedback | HTML pages with hidden sections |

An Access database to create web pages with hidden sections

This database will apply a simple set of instructions to generate tables on web pages.

Simply link other tables of data to this database and then use eiter the table itself or a query based on the query as the source of data for a web page. The table will contain a number of summarised lines, any of which can be expanded to show the detail behind it.

Example of HTML table with expanding lines.

Click on the Sub buttons to expand the details.

Produced in the 'Make HTML' Access database - program name 'HTM'.

To view the complete page and table generated by the database, click here.

The database asks for :

• the name of query (or table)
• and a description which is used as the HTML page title
• a filename for the generated file
• a flag to determine whether each expanded section has column headings
• the colours of the main and the expanded table rows
• the text appearing on the row buttons
• the fieldname which is summarised on the main table and causes an expanded section to be created

• The web page title and two paragraphs must be defined.

The selection and appearance of the various fields must then be made.

The web page can contain a maximum of 6 fields in the main table and 6 in the sub (expanding) section. Each field must be given  a title, an alignment (Left, Centre, Right), a width (pixels), a flag to show whether subtotalling required and format code for defining the appearance of numbers and dates.

Once the details have been saved, the process can quickly be called upon to generate a page whenever the data has changed.

If you are interested in this database, please contact me.

file: expandp1.htm

© MeadInKent.co.uk 2012

Last updated May12