Search results for query: *

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

Hello all, I can't believe there hasn't been a confident answer so far. Is it because my question is not clear or is it because my inquiry is NOT doable in a crosstab query? Maybe somebody, with enough experience, could take a look and lead the closing of this thread with a proper technical...

That wraps it up very nicely, Thank you!

I understand and respect your any reasons for that! Your point is clear, however that's the issue. For some numbers of [FIVE] there is column data and for some others there isn't any. How can we "ignore"/trick the column heading so that if there is data then to "move" it to the left, one next...

Yes! Your ApplicationStartupToolStripTextBox.Size = New Size(Application.StartupPath.Length * 6, 21) is the star, Thank you! Of course the same thing can be accomplished with a textbox, using more simple code, your way however should be the leading! BTW could you suggest a way to set the...

My mistake, the columns without any values should not be displayed (I did it by hand by copy/pasting the values in XL). No... left join is not the issue. Let me put it in another way: is there any way we can "forget" about the column headings and find a way to shift the data values to the left...