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

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

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

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

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

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

Hi, In my form I am checking out a tool with employeee Id and date. I want to print that particular record on the form. Just like reciept. I used the print record wizard button, but its not printing anything. Its giving out blank paper. Can any one figure it out for me. I would really...

Hi, I am having tough time to figure out how to add records to my table. I have 3 tables tbl_tool_type( tool_type_auto_number(Auto, PK), Tool_type) tbl_tools( tool_type_auto_number(lookup to above table), tool_barcode, active/inactive) There are more than one tools with same tool type but...

Hi, I am having two tables for tools tbl_tool_type(Tool_type_auto_number( auto number & PK), tool_type) other tbl_tools(tool_type_auto_number, tool_barcode. tool_acticeinactive). There can be more than one tool of same type and all that are listed in tbl_tools, but the corresponding...

I have created a form to check out a tool by an employee. The control source of the form is from a query that has all the feilds same as in the form. But the fields in the query are from two different tables. When I am adding a record, its overwriting on the first record of the query and not...