Recent content by 2314

here is the code ex.Rows(i & ":" & i).Select ex.ActiveWindow.SelectedSheets.HPageBreaks.Add before:=ActiveCell wherein i value is that of an integer and ex is an instance of excel application

hi i am getting the error when i add pagebreak and run excel from vb the first time it runs ok this error appears only next time even though i am properly closing excel err number:=-2147417851 err description:=Method 'Add' of object 'HPageBreaks' failed can u guys help out

thanks what i would like to know whether there is an event which fires on a page break

HOW DO I DISABLE AUTOMATIC PAGE BREAKS IN EXCEL OR HOW CAN I KNOW AN AUTOMATIC PAGE BREAK HAS OCCURED IN EXCEL FROM VBA

hI, WHEN I TRY TO EXECUTE IT GIVE ME INSUFFICENT PRIVELIGES ERROR EVEN THROUGH I CAN CREATE TABLE PRIVELIGE.

CAN I USE DDL STATEMENTS IN STORED PROCEDURE

thanks boss for clearing the concept

CAN U GUYS EXPLAIN ME THE SESSION CONCEPT OF ORACLE THANKS IN ADVANCE

what i mean is that when i try to get the current value of sequence without initally firing nextval i am getting the error if i fire nextval then there is no error

hI, I AM GETTING THE FOLLOWING ERROR WHEN I TRY TO GET CURRENT VALUE OF SEQUENCE EVEN THOUGH I HAVE ALREADY CREATED THE SEQUENCE AND AM USING IT IN INSERT ORA-08002: sequence SEQ_EWVGSCTNMASTER.CURRVAL is not yet defined in this session

boss it has been instatiated and the code is working fine on all machines expect for one machine

How do i define autoincrement column in oracle as i do in sql server with identity column.

HOW DO I ENFORCE A DEFUALT CONSTRAINT IN ORACLE

Hi, I am Getting error ERROR -2147217887(80040E21) Multiple step oledb operation generated error check each oledb status value avaliable no work done. This happens when i try to assign a recordset to a recordset for example on this line Set rListRs = rs.Execute(sSQL) I have already installed...

HOW DO I FIND THE POSITION OF A PARTICULAR STRING IN ORACLE