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!

  • Congratulations TouchToneTommy 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: Joelo
  • Content: Threads
  • Order by date
  1. Joelo

    Select Count query

    Please could someone tell what I am doing wrong strsql = "SELECT ZOO, COUNT(ZOO) AS prev FROM TJAB INNER JOIN TCAB AS B ON XCOW=B.BCUB" strsql = strsql & " WHERE [JOB] = "&bad&" AND [BEEV] >= "&bad1&" AND [CEEV] <= "&bad2&" AND [ZOO] like 1 ORDER BY [ZOO] DESC" Thanks in advance
  2. Joelo

    Two Submit Buttons on a form

    Please I have a form with two submit buttons. Each to cause the user to do different thing (Save Form and Submit Form) On clicking the SAVE Form Button...Information entered by the user is saved for editing later and On clicking the SAVE Form Button...Information entered by the user is...
  3. Joelo

    Auto Tabbing

    Please I am trying to get the validation function to auto tab to next textbox after min_maxCheck() function. please could somebody help me out <script language=javascript> function trigger(){ var a=document.getElementsByName('PRE_LEFTPRESSURE_<%=Ext_Record_Count%>')[0].value; if...
  4. Joelo

    Selecting Tab Dynamically

    Please how can I make the following script to Dynamically select any of below tabs that is available dim startTab tabsDef(1,1)="Men" tabsDef(1,2)="" tabsDef(2,1)="Women" tabsDef(2,2)="" tabsDef(3,1)="Children" tabsDef(3,2)="" tabsDef(4,1)="Adults" tabsDef(4,2)="" startTab=1 'the startTab...
  5. Joelo

    convert Html to asp

    Please anybody help me out in converting the following Html code to asp <td class="cssfont" width="215"><% x_MONTHYEAR = MonthName(Month(Now)) &- Year(Now) 'set default value %><input type="text" readonly name="x_MONTHYEAR" value="<%= x_MONTHYEAR %>" size=30...
  6. Joelo

    Tabbed Frame

    I would like to create my ASP page with 5 tabbed frames.... Just like the one in this forum Please could anybody help me out on how to do it. Thanks for your help in advance.
  7. Joelo

    Editable Grid in ASP

    Please I am Trying to create an Editable Grid in ASP...How can I do, if it possible in asp? Please How me out
  8. Joelo

    Converting Julian Date value to Date

    Please could anybody help me out on how to convert Julian Date value to Date (mm/dd/yy)
  9. Joelo

    SQL Query takes too long to run

    Please could someone tell me why the below SQL Query Statement take a long time run (slow in process).....It runs quite alright no Error messages. When remove the following line: strsql = strsql & " INNER JOIN JDE_CNLPRD.CNLPRDDTA.F00165 AS F on (Cast(WADOCO AS varchar(254)))=F.GDTXKY" it runs...
  10. Joelo

    Dependence Dropdown list

    I have two dropdown lists and when I select one I want to load the second dropdownaccording with the contents related to the first dropdown I.E When I select Ohio from the "State" dropdown List, I want the "City" Dropdown list loaded with cities in Ohio Please Help me out Thanks in Advance
  11. Joelo

    Converting Date to a Julian Date

    Please How can I convert 12/24/2003 to a Julian Date Please Help me out
  12. Joelo

    Advance Search, compare and display records

    I want to search for records in Table1 base on month and facility criteria and use the search results to compare records in Table2 .... and display non-matching records Please anyone with any IDEAS on how I do it Thanks in Advance
  13. Joelo

    Update a record and it's duplicates at same time

    Please anybody.....I need this Urgently. Is it possible to Update a record and it's duplicates at same time?....How can I do it Thanks in advance
  14. Joelo

    If textbox.value is a number or Text and run a function

    Please I have a Dynamic form and I'm in need of some javascript code that will check textboxes display with loop if their value content is text or number and run a function. i.e If textbox0.value is a text then do nothing else if textbox0.value is a number then run this function...
  15. Joelo

    SQL Query Problem

    Please Could anyone Help me .....I don't seem to know what I am doing wrong I keep getting the following error Microsoft JET Database Engine error '80040e14' Syntax error (missing operator) in query expression '[bsldatabase].DEVICEID =...
  16. Joelo

    Comparing Records in two identical Database

    Please could anyone help me out on how to Compare Records in two identical tables in diferent Database and copy any records that exist in table1 but does not exist in table2 to Table3 (identical) in another Database... Please really don't know where to start from.....kindly help me out...
  17. Joelo

    populating a dropdown list based on the value of a textbox (onLoad)

    Hello everyone, Please I want to automatically populate my dropdown list based on the value of a textbox onLoad of the my FORM.... both textbox and dropdown list are populated by my database i.e nos. items 1 gum 1 gum1 1 gum4 2 bolt 2...
  18. Joelo

    moving all records from one database and inserting into another databa

    I am trying to move all records from one database (databasetemp) to another database (databaseoutput) and delete all records in databasetemp leaving it blank for future use....But I keep getting the following Error: Microsoft JET Database Engine error '80040e14' Syntax error in INSERT INTO...
  19. Joelo

    VBScript compilation error

    I am run Win2000 server Please could anyone tell me what I am doing wrong....I keep getting the following error message: Microsoft VBScript compilation error '800a0401' Expected end of statement /maintenance/compliance/class_3D.asp, line 36 Public Default Function item ( k1,k2,k3)...

Part and Inventory Search

Back
Top