Hey i have a similar problem as yours and manage to solve it when i saw your code above, what my program does is to display 3 columns of value in a single multiline textbox. Private Sub txtBox02_DblClick(Cancel As Integer)ĬhangeBackColor Me.Controls.Item("txtBox02") This all works fine at the moment but we need to be able to identify which text box called the functionĬode: Private Sub txtBox01_DblClick(Cancel As Integer) There may be 20 issues each with 31 textboxes.Įach time the function runs its called from or uses the textbox label to return the data to the appropiate text box. When a permanant fix is implemented the next occurance (textbox relevant to this day) will change to green. when a corrective action occurs for this issue, using a "history" table, the text box corresponding to the day will have a background of yellow (red one remains red). The first time (during the last 31 days) that an issue occurs, the "count" or sum on that day must appear with a red background ie. The 31 text boxes correspond to the last 31 days. I have a report based on a query that counts occurances of items in a main table. I will have to look that up, but what program are you writing to? Excel, Word, Access ? and you need to pass all 31 textbox names at one time.
0 kommentar(er)
