Search results

  1. O

    calling Autofill function in excel

    I am getting total number of rows, and now trying to auofill for this number in excel spreadseet that is currently open for some reasons some times it works, other doesn't. is there an issue with the tab staying active ? 'expand the formula objActiveWkb.Worksheets("YTD").Select...
  2. O

    When i import excel file to access using vba

    Where do i specify the TAB name ? pathbgc = Path & "\ASIA - OMG Metrics " & CurrentDateText & " " & Month_Name_Long & " " & CurrentYear & ".xls" DoCmd.TransferSpreadsheet acImport, , "Accuracy-Asia-Flow", pathbgc, vbYes
  3. O

    how do i say in VBA - "Current Workbook" ?

    hello all i need to change the line For Each ws In wb.Worksheets to reference each ws (workseet) in the currently open workbook (name will be different depending on how many time app is run)
  4. O

    Refreshing Excel Pivots from Access

    Found this online breaks on this line --> PT.PivotCache.BackgroundQuery = True do i have to reference anything specific ? Dim XL As Object Dim wb As Object 'Workbooks Dim ws As Object ' Worksheet Dim PT As Object ' PivotTable Set XL =...
  5. O

    Error - "Object or class does not support the set of events"

    hey group the below error suddenly appeared today. Been using database for a few years, but lately started going back and forth between access 2007 and the older one. (getting previous version doesn't help) "The expression "On Load" you entered as the event property setting produced the...
  6. O

    Nested Query

    my least favorite query, and i am always having trouble with it COMBO ORDER VALUE x 4 45 x 3 54 y 2 12 y 8 68 I need to bring back MAX(ORDER) and the VALUE that belongs to that order - so for x - 4...
  7. O

    How make this loop run faster ?

    It pretty much does what i want it to do, but runs rather slow anything i can do to make it faster ? strSQL = "SELECT * from qryResult" Set rec = CurrentDb.OpenRecordset(strSQL) Dim cusip As String Dim spread As Integer Dim dDate As Date Dim Order1 As Integer Order1 = 1 rec.MoveFirst 'loop...
  8. O

    query - for how many days consecutive change is happening

    hi All have the following scenerio (very simplified) NAMEPRICEDATE Jean2301-Jan Jean2302-Jan Jean4303-Jan Jean3204-Jan Jean3205-Jan Ginger4501-Jan Ginger4502-Jan Ginger3403-Jan Ginger3404-Jan Ginger3405-Jan Ginger3206-Jan Ginger4507-Jan Ginger4508-Jan Ginger4509-Jan Ginger4510-Jan...
  9. O

    Having trouble with increasing MaxLocksPerFile in registry

    sorry for a common topic, but i couldn't find anything search for my scenerio I increased the number in Value Date to 2 million, yet i am stii getting this annyoing message. Few questions 1) what should i have as base - Hexadecimal or Decimal ? 2) Does 'Value Date' supposed to have 'c' at...
Back
Top Bottom