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 bkrike 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: welshone
  • Content: Threads
  • Order by date
  1. welshone

    inserting field name from a query

    hello all, how can I do this : I have a table with fields jan, feb, mar, apr, jun, and so on , in each of these fields is either a null or some value. I want to beable to run a query so I can input a month and bring back data for that month that is not null. something like : select [chosen...
  2. welshone

    update one table with data from another

    hello, how can I update table1 with data from table2 where table2.field1 = table1.field1 AND table2.field2 =table1.field2 this is with ms access 2000 thank you
  3. welshone

    Excel Line graphs

    hello, hope someone can help me with a line graph. I am attached to a datasource that is a table setup like this : servername drive drive_space date testsvr1 C 40 12/07/2004 testsvr1 D 50 12/07/2004 svr2 C 10 12/07/2004 svr2...
  4. welshone

    accessing stored procedures

    hello, how can I use a SQL server 7 stored procedure instead of a table for my crystal report ? version 8. I am trying to connect via ODBC but can only see my tables, ( no SP's can be seen) thank you for any info.
  5. welshone

    running a Call from onclick

    hello, I am trying to pass parameters from input boxes to some vb that I then want to run via a button onclick methos ,how can I do this ? so far: <BODY> <p><INPUT type=Textbox name=servername></P> <p><INPUT type=TextBox name=username></p> <p><INPUT type=textbox name=password></p> <INPUT...
  6. welshone

    access 97 calendar control

    hello, since adding a calendar control to a form some users access crashes when they try to view this form. what would be the reasons for this ? (ps, not everyone is crashing only about 5 out of 20) thanks you/
  7. welshone

    window.open

    hello, I am currently opening a page from a form using submit. then target="_new" how can I modify the windows appearence. my code is : <SCRIPT language="javascript"> function ValidateForm(){ var dt=document.s1 if (isDate(dt.Date1.value)==false){ dt.Date1.focus() return false }...
  8. welshone

    spliting data into multiple tables

    hello, is this possible ? I ran a query and the results are fed into a HTML table, can I loop through the records and add 100 records to the html table then create a new table and add the next 100 records, then create another html and add the next 100 records and so on. ? thank you very much for...
  9. welshone

    more than 3 conditional formats

    hello all, is it possible to have more than 3 conditional formats on a continuous form ? thanks for any info. W
  10. welshone

    changing box colors

    hello, I have various problems with changing textboxes and normal boxes to different colors, depending on what is in a drop down box. how can I change the color of a box I have added to my form using if statements ? eg if status = active then box.bgcolor = blue end if if have tried this way...
  11. welshone

    word macro help

    hello, how can move the cursor in a macro to the first fillin box ?I am using Word 2000 hope that makes sense ? thanks, W.
  12. welshone

    change fields border color on a continuous form

    hello all, I have created a subform on a form. The subform default view is set to continuous forms, how can I change a field's border color when I change a combo boxs value on the same continous form. eg, If cmbstatus = 1 then change txtboxName's border color to red but only for the selected...
  13. welshone

    transaction log file is full

    hello, I am trying to import many records and I get the error transaction log file is full. how can I fix this ? would a database backup fix this ? or will I need to amend some parameters in db cfg ? regards,
  14. welshone

    formatting problems when using multiple recordsets.

    hello all, I am trying to create a report in asp, in order to do this I am using multiple record sets. I want my data to look like : Area : UK County : Powys name Tel Fax Bob 123443 123456 james 11111 111112 County : Gwent name tel fax steve 123232 123122 jane...
  15. welshone

    replace function

    hello, is there a function in java to replace ' with '' . so : String Name = Replace(req.getParameter(&quot;Name_Input&quot;), &quot;'&quot;, &quot;''&quot;); ?
  16. welshone

    displaying an image

    Hello, I am trying to display an image in an Applet but am having problems. String filename=&quot;anim1.gif&quot;; anim1.gif is the name of the picture, but where do I need to copy the picture to so the applet can see it ?
  17. welshone

    Passing one parameter from many values

    hello, I have a jsp that displays all buildings like : name Address1 County Postcode ID When I click on the row ( A HREF ) I want to pass the ID to a servlet. at the moment, I can pass the ID, but not the correct one. (only passes the first one in the list) can anyone give any...
  18. welshone

    ArrayLists

    hello, loads of questions, but I am very new to this :) I have created a class that stores my establishment details like : while(rs.next()) { RS_Name = rs.getString(&quot;Establishmentname&quot;); RS_Postcode = rs.getString(&quot;Postcode&quot;); RS_County =...
  19. welshone

    passing parameter to sql query

    hello, how do I pass a parameter to an sql query ? I can type into a text box then submit it to a servlet, then open another jsp showing the typed parameter, but if I try to add the parameter like below no data is displayed : String queryString = &quot;SELECT name, Postcode, County FROM...
  20. welshone

    looping through a recordset and displaying results

    hello all, I am new to java and am trying to do a simple thing. I can connect to a database and display the first row in a jsp page, but I need to display all rows. so far I have this . // Create a Statement Object stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(queryString)...

Part and Inventory Search

Back
Top