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: *

  1. selavarti

    To Create a Access form in Visio

    hello, I am using Visio 2003 and I am trying to look for the option where there are command busttions, check boxes, combo boxes etc to create a dummie VB screen. I used them in 2002 and just can't find them in 2003. Can anyone please tell where is the option in 2003 Thanks
  2. selavarti

    Update query

    Thank you guys for the correction. Mufasa..the code seems to be correct..but it's in processing state for ever...I have to see why.
  3. selavarti

    Update query

    I am trying to update some fields in a table. But the condition for the update includes fields from other tables. Can some one please tell me what is wrong with this query. It says [1]: (Error): ORA-00933: SQL command not properly ended update ctrn set ctrn_cldt_clnt_id = 3002...
  4. selavarti

    TRIM trailing spaces of entire field

    I just realised it and finished the job. So dumb of me. Thanks anyways :)
  5. selavarti

    TRIM trailing spaces of entire field

    Hello, I have to trim trailing spaces on a feild on both sides. I did select TRIM(eqvn_name) as eqvn_name from eqvn where eqvn_name like '% '; eqvn_name is varchar I feel this is right. But after running TRIM function when I query to check if there are any with trailing spaces. It is...
  6. selavarti

    TRIM trailing spaces of a field

    Thank you.
  7. selavarti

    TRIM trailing spaces of a field

    And yes that field is Varchar
  8. selavarti

    TRIM trailing spaces of a field

    I am using SQL Navigator, but the database is in Orcale :) I am looking at the options you guys gave..thank you
  9. selavarti

    TRIM trailing spaces of a field

    Hello, I have to trim trailing spaces on a feild on both sides. I did select TRIM(eqvn_name) as eqvn_name from eqvn where eqvn_name like '% '; I feel this is right. But after running TRIM function when I query to check if there are any with trailing spaces. It is returning same set of...
  10. selavarti

    Total of a count

    I have written a count function that gives a reuslt of count of each client. How can I get he total of all the counts. Here is the SQL. select count(*) as Records, ctrn_cldt_clnt_id, ctrn_apply_code, ctrn_transaction_type_code_txt from ctrn where ctrn_cldt_clnt_id in (2201, 3002, 3014,5803...
  11. selavarti

    Not taking correct paper size

    Hi, I am giving a print command where the print style is landscape and the papaer size is 17"/ 8". but it's taking paper size as 11/8. can any one tell me what can i do to avoid this problem. thanks
  12. selavarti

    Print Legal size paper in landscape

    Hi, Can any one please tell me how to set up a webpage in CSS so when given print command it prints in Legal size paper and in Lanscape. Thanks in advance
  13. selavarti

    select a range of records between two different week nums

    try this SELECt....where ((week_no & year) >= (10 & 2003)) &(week_no & year) <= (10 & 2004))
  14. selavarti

    Query to search by keyword from FORM

    got it Thanks
  15. selavarti

    Query to search by keyword from FORM

    Hi, I am writing a query to perform a search by keyword. the keyword is accepted from the text box in the form. I have written the condition as Select..... WHERE (((tbl_issues.issue_desc)=' % [forms]![frm_issues]![text38] % ')). But this query is not working. Can anyone tell me what's wrong...
  16. selavarti

    Generating reports in Excel

    Hi, I have not used Excel much. I wanted to know if there is this feature of Generating reports in excel using some search criteria like in MS Access. If, Yes how to do it. I would really appreciate if some can get me the information. Thanks Sudha
  17. selavarti

    Change the way it shows in report

    Hi, I have a report which shows if a tool with certain barcode is active or inactive. I select the barcode and run the report. Every thing is fine..it runs. But in the report it shows the tool name , baroce and if active it shows 1 and if inactive 0. What I want is in place of 1 it should show...
  18. selavarti

    If /or / then condition

    Than kyou gary and ken I got it...
  19. selavarti

    If /or / then condition

    Hi, I am having two text fields in my form frist and last that represent names. I wrote a VBA code so that if some one leave those fileds null and saves the form it should show an error message. But for some reason its still taking null values. that is the if statement is not working. Here is...
  20. selavarti

    Print current record from a form

    Thank you I got it

Part and Inventory Search

Back
Top