Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by AnaFlorTech

  1. AnaFlorTech

    Help in a Loop

    Hello, I made a mistake in my final result. What I want to see is: Phone_number Event_Id 123 2 123 4 123 6 123 8 Thanks
  2. AnaFlorTech

    Help in a Loop

    Hello, I have a cursor that have the following data that I select from a table: Phone_number Event_Id 123 1 123 2 123 3 123 4 What I want to do is to increase a number in the event id every time he does...
  3. AnaFlorTech

    Run a macro in another sheet of excel

    Can I send you my excel file for you to see what's happening please? I'm sorry but I don't know much about vba. Thanks
  4. AnaFlorTech

    New to Microstrategy, rows disappears when column value 0

    have you tried in the report, data menu, report data options? You have a null values tab where you can choose to appear 0.
  5. AnaFlorTech

    Run a macro in another sheet of excel

    I did all that but It still doesn't work.
  6. AnaFlorTech

    Run a macro in another sheet of excel

    I'm sorry.Is that I am a little bit confused for so many changes that I've made for run this 1) the sheet that you are CHANGING a value in column G Sheet 1 named Requests 2) the sheet that your Filtered table is in Sheet 1 named Requests. In here I've created a table with columns STATUS_VALUE...
  7. AnaFlorTech

    Run a macro in another sheet of excel

    Hello, Now the macro doesn't run anymore. Not even when I run it mannualy. And when I change a value in Sheet 1 it doesn't do anything also.
  8. AnaFlorTech

    Run a macro in another sheet of excel

    Here it is: Sub STATUS_DONE() ' ' STATUS_DONE Macro ' ' Range("A1:L1").Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlDown)).Select ActiveWindow.SmallScroll Down:=24 Selection.ClearContents ActiveWindow.SmallScroll Down:=-3...
  9. AnaFlorTech

    Run a macro in another sheet of excel

    Hello, I did what you said: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("G:G")) Is Nothing Then Call STATUS_DONE End If End Sub But when I change column G for one record to DONE in sheet 1 the macro doesn't run. I still don't have in sheet 2 the...
  10. AnaFlorTech

    Run a macro in another sheet of excel

    Hello, The heading of the column is "Status" and is the G column. Thanks.
  11. AnaFlorTech

    Run a macro in another sheet of excel

    Hello, I have an excel workbook with 3 sheets. In the first one, I have listed all the requests that were made to me. And one of the column of sheet 1 has the status (Made, Pending). The second have the subset of requests that are already done and the third sheet has the requests that are still...
  12. AnaFlorTech

    Help: DataStage 7.5.3 and Oracle RAC 10G

    Hello, We have DataStage 7.5.3 installed on an HP/UX machine. Our database was an oracle 9i instance. Last week we bought a new DB server. It's an Oracle RAC with 10G Version. When we were running some test we found two diferent problems: 1) Our dsx server had oracle client 9.2.2 and then...
  13. AnaFlorTech

    Union All in 10g

    Hi, The indexes were rebuilded after the upgrade and all the statistics that were lost, are now up to date.
  14. AnaFlorTech

    Materialized view that doesn't run

    I have a select query script that runs fine. I am trying to create a mview with it but when I try to create the view,it runs and runs and never creates the view; I have to cancel. I let it run for an hour without success, the actual select query takes about 5 minutes. If I use the select in a...
  15. AnaFlorTech

    Union All in 10g

    Hello, In 9i I had a procedure that opens a cursor with a select with union all inside. Then, the values of the cursor are inserted into a table and it gives a commit each 10000 rows. After upgrading to 10g, the procedure that used to take about 1min to run, takes over an hour. Could you...
See more

Part and Inventory Search

Back
Top