Search results

you mean Range(Y).Selection.AutoFill ? that doesn't work at all...

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

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

tx, works perfectly ! :))

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)

i do have excel 12.0 object library referenced do i need this line ---> ObjXL.Workbooks.Add ? get "Application-defined or object defined error'

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

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

hey Brian - thats what i ended up doing, but back in the old days i was able to d oit in 1 query.. I guess 2 is fine

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

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

hi Bob Access 2003 getting MaxLocksPerFile error when i am trying to assign AutoID to table that has 195,000 records

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

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