질문하기

# martouf's profile - activity

 2017-06-05 18:44:23 +0200 받은 배지 ● 유명한 질문 (source) 2017-03-31 03:43:57 +0200 받은 배지 ● 개근상 2017-03-28 05:28:44 +0200 질문에 댓글을 달았습니다 Code counting -- How to tally and use table data to validate input Yes, EasyTrieve, you have the general idea. I get a clean trigger of a macro using a textbox and the event 'changed' -- clean meaning it is triggered after a whole code is input. I like the behavior of a combobox with all the codes pre-loaded but the event 'text changed' fires on every character input. I tried to have the macro wait until the whole code is entered, but it is getting the input character-by-character instead of string-at-once. 2017-03-27 16:37:36 +0200 받은 배지 ● 조력자 (source) 2017-03-27 16:37:31 +0200 받은 배지 ● 학자 (source) 2017-03-27 16:36:56 +0200 코멘트달린 답변 Code counting -- How to tally and use table data to validate input THANK YOU for a working example of (what should be) a Simple Thing. I had started off with a old code example that triggers an InitForm subroutine on the "when loading" event in a form (that much worked fine) which creates the database connection and is supposed to set a subroutine UpdateTable to be called upon an object event. An added challenge: some of the example references methods which are no longer in LibO 5. Thanks to you, I have a solid foundation I can refer to and examine in detail. 2017-03-27 15:43:20 +0200 코멘트달린 답변 Code counting -- How to tally and use table data to validate input To be clear, in no way has communicating with you been difficult. You have been remarkably responsive. Even though I referred to many sources, read quite a bit of documentation, performed many tests using the design and debugging tools provided, and tried to make sense of the results, implementing a tally sheet has been more difficult to accomplish than I ever imagined. 2017-03-27 06:20:31 +0200 받은 배지 ● 주목할 만한 질문 (source) 2017-03-27 05:25:35 +0200 코멘트달린 답변 Code counting -- How to tally and use table data to validate input Macro coding and assigning subroutines to events are familiar to me. Why it is this task would seem more difficult to accomplish than coding a GPIB interrupt handler, I don't know. 2017-03-27 03:06:06 +0200 받은 배지 ● 논객 2017-03-27 03:06:06 +0200 코멘트달린 답변 Code counting -- How to tally and use table data to validate input Did I mention the "fun" I had for a while because I named the tally column "Count"? Oh, the hours lost to that.. Well, there you have it, now I have mentioned it. 2017-03-27 02:49:50 +0200 코멘트달린 답변 Code counting -- How to tally and use table data to validate input if "Entry" came from a barcode scanner, I would do that. But the codes in this task are not bar codes. They are strings of five characters. The example codes I provided are representative even if they differ slightly in detail. I intended to type codes in, and trigger a tally increase upon hitting the key. The combo box scrolling to the relevant part of the list of codes was the best UI design. And a mouse click on a code in the list would serve as well. 2017-03-27 02:41:59 +0200 코멘트달린 답변 Code counting -- How to tally and use table data to validate input When this person sees a code, they make a tally mark on the tally sheet next to the corresponding code. The codes are grouped and after making each tally mark, the person can take note of the counts of all the rest of the codes in the group. The code counting does not stop until there are no more cards. Getting at least one count of each of the codes in a group is not a stopping condition. 2017-03-27 02:30:08 +0200 코멘트달린 답변 Code counting -- How to tally and use table data to validate input Yes! yes! for goodness sake, yes! The form should help to permit only valid codes to be entered and increase the tally each time a code is entered. Have I not been saying that all along? That's how a tally sheet works... 2017-03-27 02:27:41 +0200 코멘트달린 답변 Code counting -- How to tally and use table data to validate input I really am not sure how else to explain I wish to create a tally sheet. Shall I describe what a person would do with a piece of paper and pencil? The paper would have on it at the start the list of codes and a space to the right of each code to make a tally mark next to a code. The person is handed a stack of cards, each card has one code printed on it. The only codes the person will see on the cards are known in advance and are already on the tally sheet. 2017-03-27 02:22:12 +0200 코멘트달린 답변 Code counting -- How to tally and use table data to validate input No, I don't want to know how many are missing. I want to count how many times each might be entered as input data. I had no intention of offending you by asking if you knew the word 'tally' and I apologize if you took offense. I would hope you pay attention to all the words (not just 10%) I make the effort to write. 2017-03-27 02:17:26 +0200 코멘트달린 답변 Code counting -- How to tally and use table data to validate input I am sorry if you find this confusing. I know code E5C, for example, can only exist once in the table. It is unique. I only want to keep a count of how many times I observe a code and type it in to tally it. All valid codes are known in advance, but not all codes will necessarily be observed and counted. In different attempts, I built both list boxes and combo boxes with all the valid codes to help with data entry of only valid codes. 2017-03-27 02:04:00 +0200 코멘트달린 답변 Code counting -- How to tally and use table data to validate input None of the various things I've tried have achieved the goal, so I didn't include the attempt to use LibO BASIC or any of the versions of the Forms which didn't work. If it helps, think of this as a sort of inventory problem. I thought I have been very clear in my descriptions of the task and that the task is a simple one. I intend to create was is in essence a tally sheet. 2017-03-26 23:26:32 +0200 코멘트달린 답변 Code counting -- How to tally and use table data to validate input Okay, thanks for the response but you're misunderstanding the task. Please refer to my comment with the attached example database, and I hope you will understand the task. 2017-03-26 23:24:25 +0200 질문에 답변하였습니다 Code counting -- How to tally and use table data to validate input There is a reason for "tally" .. i want to count the number of times the code E5C is encountered and entered, for example. I may or may not (by the time all the codes are tallied [that's another word for 'counted']), have at least one observation of code E5E. But if I get code E5D, I need to count it and I'd like to see as I go if I have encountered at least one of every code in code group E5. Example database is attached. TallyDatabase.odb ps: do you not know the song "Day-O (The Banana Boat Song)" ? or the term 'tallyman' ? https://en.wikipedia.org/wiki/Tallyman 2017-03-26 23:17:22 +0200 받은 배지 ● 인기있는 질문 (source) 2017-03-26 17:36:32 +0200 받은 배지 ● 학생 (source) 2017-03-26 17:30:28 +0200 질문에 댓글을 달았습니다 Code counting -- How to tally and use table data to validate input left out the mention of the primary key in the second table. 2017-03-26 17:27:57 +0200 질문하였습니다 Code counting -- How to tally and use table data to validate input I have been working on this for two days with reference to LibO Help, OO Documentation, StackExchange, and whatever else internet search engines could provide. I have managed various values of 'success' and even crashed LibO Base once, but have not managed to complete what I think is a simple task. My head aches from banging it against this cognitive wall. I must be missing something which is not made clear by any example or tutorial seen so far. I have two tables. The first and simplest table is omitted from the sample database attached. This first table is just "CodeGroup" and "Description" (both columns are strings) -- it provides descriptive name for each code group -- with CodeGroup as primary key. I will use it for making the automation look nice later, so I left it out. The second table is "CodeGroup", "Code", and "Tally". The first two columns are strings, and the last is an integer. The table already contains the data which is static and has no need to change -- the code group and the codes. The "Code" column is the primary key. What I am trying to do is use the codes already in the table to provide a list box or combo box which autocompletes as a code is being typed (fixing lowercase and validating input at the same time) and then, once is pressed, increases the tally value by one, and make ready for the next code. I would also like to display all the codes and tallys belonging to the same code group after each code tally is updated. Seems really really simple, yes? I thought I might find a working example or tutorial but nothing I found is designed this way. I am at a loss why I cannot complete this task. I have been experimenting with Forms and Subforms and List Boxes and Combo Boxes and Formatted Fields and Text Fields and SQL and Control properties and Forms properties and on and on ... I will greatly appreciate expert assistance and give many thanks. ps: oh. :( i must have 3 karma points to upload the sample database. and I have but 1. I'll append an excerpt of the data below (you'll see the pattern. the real data is different only in detail. each code is unique. each code group contains a varying number of codes, ranging from 4 to 8. the sample has code groups A1 to A5, B1 to B5, and so on, to E1 to E5): CodeGroup Code Tally A1 A1G 0 A1 A1F 0 A1 A1E 0 A1 A1D 0 A1 A1C 0 A2 A2G 0 A2 A2F 0 A2 A2E 0 A2 A2D 0 A2 A2C 0 A3 A3G 0 A3 A3F 0 . . . E3 E3D 0 E3 E3C 0 E4 E4G 0 E4 E4F 0 E4 E4E 0 E4 E4D 0 E4 E4C 0 E5 E5G 0 E5 E5F 0 E5 E5E 0 E5 E5D 0 E5 E5C 0