Search results for query: *

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

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

I am not an Access Programmer. I am a programmer in Visual basic and oracle. I've used Access only for Database..... I am coming to the problem......I have been asked to develop an access application. This application should have 5 screens(forms) and access tables. 10 users will be using the...

I am using oracle discoverer for 40% of my financial reports. I am also using Excel sheets for reports, graphs etc. From my excel reports, i am connecting to oracle 8i with Oracle Objects for OLE.(OO4O). If my discoverer reports work, then all my excel reports are not working. Then i...

i got this error when i accessed oracle tables through my COM+ component. I have read all the docs. related to this and configured the system. But still i get the error " cannot connect to the transaction manager or transaction manager is unavailable". What could be the problem?

My application uses Oracle 9.0.2 as back end and my component resides in COM+. All the components uses transactions. Out of 10 desktops, 8 are working perfect and the other 2 machines are throwing the system error. Cannot connect to the transaction manager or transaction manager unavailable. I...

I have created a line graph (comparison graph) in Crystal Report which access oracle stored procedure. My requirement is to display the legend (below on chart) and with legend markers on the left side. Though i could able to make it design time, the legend gets overlapped during runtime. I am...

We are designing an web based application for our client. All the users are very familiar with microsoft office product. They have huge amount of data in ms-excel files. They will upload the excel files(on a daily basis) through the browser. The excel file will be sent to the middle tier and...