Recent content by kiransalu

Excellent. Thank you very much for all of your answers.

Sum(A:A) counts all the rows. Out of 10 rows i should count only the first 9 rows and then match it with the 10th row.

I have an excel sheet which fetches data from Oracle DB using OO4O macros. There are 3 columns from the DB. A B C 1) 1 3 4 2) 3 5 6 3) 7 4 7 Total 11 12 17 Using VBA i have to sum column A (1+3+7=11) and compare with the total.(last row). Rows are dynamic...

I have a sheet called "Data". I am filling this sheet (2 columns Fund name and Fund ID) from Oracle DB. Everyweek there is an increase in the funds list in DB. So i have to refresh the sheet from oracle. I have also a dropdown which has input range (Fund Name) from the data sheet. Input Range...

Wow. Excellent. It's working now. Thank you very much.

It shows three properities Input Range Cell link Dropdown lines. Now i want to dynamically set the input range for this control. When i go VBA i couldn't find the name of this control. how do i set the range during run time.

I am new to Excel Macro VBA programming. My requirement is to download a records from Oracle DB to excel. Then the business users modify the data in the cells and then upload it back to Oracle. For Ex. I am downloading the below data from Oracle. Fund Id, Fund Name, Returns. I want to show...

I am loading 5 fields to a table which are in the flat file using sql*loader. I also need to insert default vallues for 2 other fields which are in the table but not in the flat file.(SYSDATE and a constant) how should i do that? Expecting earlier reply.

Wow Excellet Mufasa. Keep it up.

I have two schema in the same database. Map and Vendor The tables in the Map schema gets loaded through some external application. Now i want to write a SP in Map schema to push the data from MAP to Vendor schema. I have to apply various business validations before inserting data to Vendor...

rkirpane, Thanks for your reply. I checked the Oracle DB, password grace period option was not checked. I would like to add one more information here.... We are four developers using Windows 2000, COM+, IIS and oracle client 8.1.7. Oracle server is 9.0.1 The same application works in two...

We are using Windows 2000 Server, Oracle 8.1.7 client and com+. MSDTCORA test ran successfully. When we use supported transactions in the component, application works fine. If we change the components transaction to required, then we get the below error. "Method of object failed". -2147430328...

Thankyou very much buddies. I am using Date() function in my query. All the best in your future endeavours.

How do i select current date from my access table? I have four columns in my table. I have created a query for that table and i need to add a column called current date. I need to select current system date in that column. Is is possible?

Thankyou very much. It's working now.