Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: GKIL67
  • Order by date
  1. GKIL67

    Find Repeating Patterns of Numbers

    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]
  2. GKIL67

    Find Repeating Patterns of Numbers

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

    Find Repeating Patterns of Numbers

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

    Find Repeating Patterns of Numbers

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

    Find Repeating Patterns of Numbers

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

    Find Repeating Patterns of Numbers

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

    Find Repeating Patterns of Numbers

    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?
  8. GKIL67

    Find Repeating Patterns of Numbers

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

    How to pass numbers from a string using the In()

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

    How to pass numbers from a string using the In()

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

    How to pass numbers from a string using the In()

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

    Transpose query, Rows to Columns

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

    Transpose query, Rows to Columns

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

    Cell elimination (hiding) of a crosstab query

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

    Cell elimination (hiding) of a crosstab query

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

    Cell elimination (hiding) of a crosstab query

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

    VS2008, ToolStripMenuItem handling

    That wraps it up very nicely, Thank you!
  18. GKIL67

    Cell elimination (hiding) of a crosstab query

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

    VS2008, ToolStripMenuItem handling

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

    Cell elimination (hiding) of a crosstab query

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

Part and Inventory Search

Back
Top