Search results for query: *

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

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.

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

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

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

Thank you.

And yes that field is Varchar

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

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

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

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

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

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

got it Thanks

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

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

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

Than kyou gary and ken I got it...

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

Thank you I got it