Search results for query: *

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

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

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

Hello all, do you know if there is a simple way to eliminate/hide the empty cells in a crosstab query? Kindly see the attached picture, I want to get from the original Display 1 to Display 2. The column headings (1301, 1300, 1299...) is only an increasing counter... maybe there is a way to...

Hello all, I have a MenuStrip like this: FILE ==> CURRENT DIRECTORY ==> textbox When CURRENT DIRECTORY is selected, it displays the Application.StartupPath in the textbox, but the textbox isn't large enough for the text of the path. There must be a way to re-size the textbox, depending on the...

Hello all, Happy Holidays! I have a table, DRAWtbl, having the fields IDcounter, date and five number fields (each number field can have values 1-49). I would like a function i.e. b2bhits("IDcounter", "number") that would return from the last record and up to the "IDcounter" the number of...

Hello, this is quite complex... I'm trying to come up with a function that for N numbers generates all possible combination in sets of K of them. The numbers N are not always sequential, they appear only once and they are fed as a string parameter, separated by ",". The K is not always known...

Hello all, I'm trying to simulate a numeric pad where values range from 1 to anything, no gaps - via an ms access form. My issue is how to avoid repeating the subs for each toggle button, as for i.e. 100 buttons I have to add and modify 100 subs. Also, how to empty the string from the...