Recent content by GKIL67

That's a great help and a lot of good homework... it does help to break it down to two functions! Thank you MajP, once again! [thumbsup2]

I made the change, Cool! I have to say it's lighting fast! I fed 75 rows by 45 columns and it was ready as soon as I hit [enter]. Great MajP! Now, would you please satisfy my curiosity and help me develop my programming with the function that searches a comma delimited string of numbers and...

Can't get it... I get error 3265 "Item not found in this collection" and hangs at: Public Function GetColumn(QueryName As String, ColumnNumber As Integer, Optional LocationColumnNumber As Integer = 0) As ColumnItems Do While Not rs.EOF col.Add rs!location, rs.Fields(columnFld).Value...

I've spent the last 3-4 hours with it. No doubt on the logic and the perfect structure used, but I'm an Access 2003 user and besides the "User-defined type not defined" and other errors I get, I'm not so familiar with classes and etc. mentioned. So, MajP's approach is a star, but I can't really...

Hello, still can get it... Maybe MajP, could you take me a step further? If you think that it is too hard, maybe to look only at a function that searches a comma delimited string of numbers and returns in a table the repeated patterns, as specified by X? i.e. strNumbers =...

I really couldn't follow, programming wise, what you post in the beginning as "So here is the basic logic." But at the end, you say "I will probably skip tables and queries and do it mostly in code. A main routine can pass in the original query name, the column number, and the amount in...

That is actually the role of parameter X. Based on your sample, For X=2, acceptable are 12,12,12 and 23,23,23 and so on... For X=4, acceptable are 1234, 1234. Thank you MajP, do you think you have a way for me to handle it?

Hello, I have the output of a crosstab query that has finite number of columns [BALL] as numbers (i.e. 1, 2, 3... 45) and each row [CNT] has a unique ascenting number as a name (i.e. 137, 138, 139...). The value [SKIPS] can be any number, including 0. Each column could start or end by a NULL...

Indeed, the Instr() is the most simple way to get it done, especially when seeking results mostly with queries. Thank you!

Great! I got it to work using instr(), although it was more complicated because the logic had to be applied to 5 fields and then select only those that match the filter... And the "," had to be a ";" in order for the query to work. Would it be too much to ask a bit more about your comment: "to...

Hello all, I have a text filed [Nos] on a form [CheckNos] containing a series of numbers such as "6;11;20". I want to pass them in a query as a filter, using a button. The query has in the respective field as criteria: In ([Forms]![CheckNos]![Nos]) How can I use the In() to retrieve all...

It works, straight to the point! Thank You so much for your help!

I have the table tblpatskips: DrawNo BALL SKIPS 1 5 3 1 12 16 1 18 2 1 20 11 1 32 7 2 2 3 2 6 1 2 23 1 2 24 9 2 42 2 Where DrawNo is an ID counter, BALL values are 1-45 and SKIPS can be any number. I need to transform it to: DrawNo BALL1 BALL2 BALL3 BALL4 BALL5 SKIPS1 SKIPS2 SKIPS3 SKIPS4...

Well, skipPat45Rows shows for a lottery game each BALL how many SKIPS passed before the BALL appeared last time and DrawNo is the increasing counter of all the drawings. For example, BALL no 1 has SKIPped 12 drawings and last appeared on DrawNo 1291. BALL no 2 has SKIPped 5 drawings, last...

The use of the table [5&20] is only to force the appearing of all numbers (field [FIVE] = field [BALL]), from 1-45. To make it more simple we can exclude it, so we get the: TRANSFORM First(skipPat45Rows.SKIPS) AS FirstOfSKIPS SELECT skipPat45Rows.BALL, Count(skipPat45Rows.SKIPS) AS TotalSKIPS...