Recent content by mthompo

many thanks - went with chris' solution as works great anyone who reads this dont forget to remove the 140 padding on tabs2 ul thanks again

thanks for your reply added this style #headermenu {margin:0 auto;width:100%;height:100px;float:center;text-align: center;} added to #tabs2 #tabs2 { text-align: left; width:100%; font-size:93%; line-height:normal; border-bottom:1px solid #84776B; } changed html to <div id="headermenu">...

have the following css to put a top bar menu on the page but cant get the menu to center in the page it uses 140px in this line padding:5px 5px 0 140px; ...to start the menu 140pixels from left - but i want the menu to center in the page - have tried float:center all over the place but doesnt...

forgot to give a star *

thanks tarwn - your reply was very helpful and clearly explained the opions available - went number two as this was the simplest! changed the sql order and added this line after the do while loop for both lists [except changed the holtypeid to 2 for the second list!] if holtypeid <> 1 then...

also tried putting in if not (rsside.eof) then rsside.movefirst end if but of course this wont work because after the end of the first list the rs is eof so it never movesfirst

Hi, have the following code which makes two lists a list for holtypeid =1 and a list for holtypeid =2. i dont want two rs, so i goto the first record for the second list using rs.movefirst so the loop starts again - which is fine as long as there are records for holtypeid =1 or 2 , else i get...

quite right - thanks to all

many thanks added () around date clause' SELECT courtcarbook.courtcarbookid, courtcarbook.bookst, courtcarbook.bookend FROM courtcarbook WHERE courtcarbook.carid =14 AND ('20061028' BETWEEN bookst AND bookend AND '20061028' BETWEEN bookst AND bookend OR (courtcarbook.bookst <=...

have the following sql that finds booking spaces that are already booked if the recordset is eof then the space is free i want the query to not include bookings that are the same as the booking being edited SELECT courtcarbook.courtcarbookid, courtcarbook.bookst, courtcarbook.bookend FROM...

many thanks

ok - think it was a date issue in the sql preliminary tests show this works fine :):):):):):):):):):):):):):):):):):):):):):) 'sql sql= "SELECT cus.lname, CC.reg, CBB.bookst, CBB.bookend, CC.carid, CBB.courtcarbookid,tran.trandesc, CC.model "_ & "FROM courtcar AS CC "_ & "LEFT JOIN "_ &...

oops year var was wrong - should read whenstart =date() motdaynumsql = day(whenstart) motmonthsql = month(whenstart) motyearsql = year(whenstart) 'sql start daysql = motdaynumsql if daysql < 10 then daysql = "0" & daysql end if monthsql = motmonthsql if monthsql < 10 then monthsql = "0" &...

ok have written some script that changes standard UK date format dd/mm/yyyy to mysql query format yyyymmdd whenstart =date() motdaynumsql = day(whenstart) motmonthsql = month(whenstart) motyearsql = year(whenstart) 'sql start daysql = motdaynumsql if daysql < 10 then daysql = "0" & daysql...

ok - thanks...sure that worked friday! (SELECT CB.bookst, CB.bookend, CB.carid, CB.courtcarbookid, CB.cusid FROM courtcarbook AS CB WHERE (cb.bookst BETWEEN '20061015' AND '20061021') OR (cb.bookend BETWEEN '20061015' AND '20061021') OR (cb.bookst < '20061015')...