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...
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.
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...
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?
I have an access form with Tab control. Tab control has 3 pages which contains three sub forms. Whenever i first load my main form, i should show up from the center of the application and window width should be full view. I don't know how to make these settings in the main form.
I am using a subform datasheet view in a main form. During run time, if i right click the main form, i get properities option. Once i select the properities option, i am able to select various properities.
I need to prevent properities option. How to do?
I am using Access 2002 for my new project. I have created a form from a table and changed it to datasheet view. The datasheet view contains 24 columns...It contains 35 records in the view.
Based on my first column in the third row value, i would like to disable 3rd,4th and 5th column in the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.