Search results for query: *

Hi bslintx .. just trying out your idea and get back to you - its the weekend !!!

How do I trigger the following SQL statement from a graphic 'update' button on an ASP page UPDATE addressbook INNER JOIN newaddress ON addressbook.PersonID = newaddress.PersonID SET newaddress.add1 = addressbook.add1 Any ideas ? Cheers chaps

How do I post a form to 2 different pages i.e. on submit go to 1.asp and 2.asp cheers

Thanks Chaps . dhookom ... your code worked fantastic, your my hero. steven290 ... cheers for your help - this seemed to give a little trouble because there where no joins - dont know why, Access told me. Thank anyway Thanks guys

Sorry dhhookom - here are the full fields for both tables. Just thought I would summerise it.. here goes ------------------------------------------------------- Table (table 1)= addressbook (the table I want to add 'Forename' to) addressbook.PersonID =(primaray key, auto number)...

hi dhookom - the primary key is PersonID in the recieving table (table 1 ) ... Thank you PHV - having a look at your idea, cheers

cheers dhookom ! Can you help me with the update query not sure what to do - Im into ASP and need to do this for a projetc. Thank You Thanks BNPMike - im writing ASP based insert queries and this exercise will make this easier. Cheers

Is there a way of moving a field from one table to another ? i.e. (in short) Table 1= surname, telephone, address Table 2=email,firstname I want to move all the 'firstname' field contents from table 2 ( 11,000 records)into table 1 but aligned to the right surname etc. They have a common field...

How do i make a dropdown box populated from a MS Access database.Ive searched the faqs etc but have not found an answer i can work with. The first dropdown would show a straight list from a table 'Select CourseID, from Coureslist', Making a selection in this box would then get the details...

How do i make a dropdown box populated from a MS Access database.Ive searched the faqs etc but have not found an answer i can work with. The first dropdown would show a straight list from a table 'Select CourseID, from Coureslist', Making a selection in this box would then get the details...

I need to write a query looking for a date in say 'date1' in table named availability. BUT i would like the result showing '+' or '-' 2 weeks either side Any ideas ?

I have the following query (used on an ASP page) ------------ SELECT * FROM volunteer WHERE qualification='qual' AND AvailabilitYFrom1=#aval# --------------- The 'AvailabilitYFrom1' is a date. I want to return the date with + and - 7 days either side of it. Any body help ??

Excellent. Thanks so much ! You truly put the 'vb' into vbkris ! check out www.igd.uk.com

Yeah it needs to formt the 'mailto:' link.The 'stb_recipient' writes the email address from the items above it

Thanks vbkris ...Ive tried that but still does not show. Here is the full code. <table width="999" height="74" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="340" background="images/homebotoomleft_14.gif"><table width="340" border="0" cellspacing="0" cellpadding="0">...

I have the following code and want to format the output text with a CSS style called 'whitetextsml'. Can anybody help ? CODE------ <script language="JavaScript"> <!-- var stb_domain = "igd.uk.com" var stb_user = "office" var stb_recipient = stb_user + "@" + stb_domain var stb_url = "mailto:" +...

Thanks Tarwin ! http://www.igd.uk.com/plants/1dracaena.asp Works fine now :-)

whoops error !! Its displaying but not showing the CSS style

Ref: http://www.igd.uk.com/plants/1dracaena.asp Please go to the above link to see problem. I have a problem with the final record, in the record set, displaying the detail text under the picture.It only seems to happen when there are not two records displaying next to each other.When you click...

Cheers Tony - Thanks for pointing me to the right place. I getting my commas wrong in the syntax.