Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mazdaman
  • Order by date
  1. mazdaman

    Use 'UPDATE' in MSAccess

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

    Use 'UPDATE' in MSAccess

    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
  3. mazdaman

    post to 2 different pages

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

    move field into another table

    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
  5. mazdaman

    move field into another table

    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)...
  6. mazdaman

    move field into another table

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

    move field into another table

    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
  8. mazdaman

    move field into another table

    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...
  9. mazdaman

    classic dropdown questioin

    ...'Select CourseID, from Coureslist', Making a selection in this box would then get the details from the following query 'SELECT Applications.*, Courselist.*, Coursetitles.* FROM Coursetitles RIGHT JOIN (Courselist RIGHT JOIN Applications ON Courselist.CourseID = Applications.CourseID) ON...
  10. mazdaman

    Classic dropdown question

    ...'Select CourseID, from Coureslist', Making a selection in this box would then get the details from the following query 'SELECT Applications.*, Courselist.*, Coursetitles.* FROM Coursetitles RIGHT JOIN (Courselist RIGHT JOIN Applications ON Courselist.CourseID = Applications.CourseID) ON...
  11. mazdaman

    range between dates

    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 ?
  12. mazdaman

    Dates. + and - days around it

    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 ??
  13. mazdaman

    format text

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

    format text

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

    format text

    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">...
  16. mazdaman

    format text

    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:" +...
  17. mazdaman

    Disappearing Records ?

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

    format text in document.write

    whoops error !! Its displaying but not showing the CSS style
  19. mazdaman

    Disappearing Records ?

    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...
  20. mazdaman

    format text in document.write

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

Part and Inventory Search

Back
Top