First lets get a couple of things out of the way

1. I am not a web designer
2. I am not a computer programmer

The truth is that I like to play and in playing I have learnt a couple of things about web design, and because this is not something I do regularly, I may forget how to do certain things and therefore this section of the site is where I plan to store the knowledge I have gleamed from various books and websites in my endeavour to find out how to get something done. I may not have answers for a question that you have - this is purely my repository!

Helpful Hints

Buttons

For fancy buttons use the following bit of code:

<Input type="submit"
class="clrbgwhite"
onmouseover="this.className='clrbgwhite clrhov'"
onmouseout="this.className='clrbgwhite'"
value="Search">

Tables

To enable alternating colours in tables, ensure that there is a style for tr class="alt" then use the following code which is for Cold Fusion:

This initially sets class=""

<CFSET LocalColour="">
<TR class=#localcolour#>

This performs the looping to alternate the colours for each row of data

<CFIF localcolour EQ "alt">
<CFSET localcolour="">
<CFELSE>
<CFSET localcolour="alt">
</CFIF>

Access Databases

This one always confuses me: For when you have a data of data and you want to update one field only with new data - for example the data you have contains last years sales and this years sales so you want to add the two together to get total sales, this is what you need to do

Using the Update Query show the table that you want to hold the data, ie tblSales. If you are using another table to provide the data, show this table as well and link the two with the relevant field, ie. Product.

In the second part of the query have the following,

Field:	Name of the field that you want the data to be entered into, ie. TotalSales
Update To:	Name of the field that you want the data to come from, ie [PrvSales]+[TotalSales]

The Update To always confuses me as I always think that is where it is going to Update To!