Recent content by VickyC

hi prex1 Thanks for those two good ideas. I'm guessing it should also be possible to use the numpy.where, but I haven't been successful yet (ie: iterating through the array values to determine the indices of each value. That could be the fastest of all.

Consider a numpy array like this... a = array([1, 7, 2, 8, 1, 2, 3, 8, 5]) Some of the array elements appear just once (ie 3, 5, and 7), but we are interested in the array elements that appear twice (ie 1, 2, and 8). I need to find the GAP (index difference) between identical elements. In...

Thanks for responding, Andy. You're right - the point is... on which record in this table? That brings it into clearer focus. For each table that matches "tbl_*", I want to count the records where Field sType = "K". . How could I set that up? Thanks, Vicky

hello all Consider the code fragment below. I loop through a set of tables in an mdb file. If the table matches "tbl_*", then I call a function. This works PERFECTLY. Dim db As DAO.Database, tdf As DAO.TableDef ... Set db = Workspaces(0).OpenDatabase(strExternalPathName) For Each tdf...

hey Duane - Works perfectly! Thanks, Vicky

hi I have a huge table like the one at LEFT. For each ID, Rank runs from 0 to 4. The ID increments by 1 after each set of 5 records. I want to insert a new record at the beginning of each group of 5 records. This is shown at RIGHT. For each of these new records, the last 3 fields are -1...

thanks, Skip, for a quick response, and for the advice. Vicky

hi - I'm totally new to Excel VBA. I've need code to copy the tables in a set of worksheets into Sheets(1). All works perfectly. But, I now want to fill the header row cells of each table using, say, colorindex = 37. As I loop through Sheets(2) to the end, I run the following code...

VickyC - I'll retract the question! The answer is obvious.

hi I want to use 2 Long args and 1 ParamArray in my function below... Function TEST(X As Long, Y As Long, ParamArray Arr() As Variant) Debug.Print LBound(Arr), UBound(Arr) Debug.Print Arr(0), Arr(1) End Function When I run TEST(10, 20, 5, 3), the output is... 0 1...

hello to all Here is a sample from a table... (* sorry, but I can't get the TGML to show the tables properly??? I'm using tt and /tt in square brackets) Row DataVal 1 7 2 2 3 8 4 -2 5 -3 6 -4 7 -8 8 4 9 5 10 -6 11 -7 12 3 13 6 14 -5 I need help writing a query to a) Group...

skip - nice answer!

hello I have a question that has me stumped. Consider a large table as shown below... ID A B X1 X2 X3 X4 X5 X6 ==================================================================== 1000 1 6 1 6 6 10 6 1 1001 3 15 15 15 3 3 3 3 1002 13 8 13 8 13 8 8 13 1003 34 16 99...

hi to all. I have thousands of reference tables with names like tRef__nOT_4_sOTX_12_v23. These are stored in multiple MS Access 2002 mdb files. Recently, a problem has arisen, and I think it may have happened when I switched from Windows 7 to Windows 10 (not sure). Here's the problem: The...

hi Skip - you're format suggestion worked. What puzzled me was that my code worked in the past. I moved all tables, queries... into a fresh mdb file, and now my original code works once again. Thanks for taking the time Vicky