Search results for query: *

Thanks for this - but my problem was with the dataerror method because I did not want to include the whole dataset in the datagrid. I do have validation working with the cellvalidation method. Thanks for the help Kim

My contract has ended so I won't get the opportunity to get this piece of the project completed - so no need to reply Thanks for all the help!!!!!!!!!!!!!!!!!!!! Thanks for the help Kim

Could .DefaultValuesNeeded be part of my solution? Does this only work if I have the columns being displayed on the datagrid? Thanks for the help Kim

Thanks for the posts - I actually had looked at that validation tutorial - I had not yet put the CellEndEdit into my code because the comments on it said "for when the user press esc"; but I was only tabing thru the fields; I hadn't realized it got rid of the icon I just thought it cleared the...

When I tab off the last field the error icon disappears. But so does my whole line. I'm trying to understand how all this cellvalidating and dataerror works together. So because I don't have this working properly maybe this is not the time to ask about this icon. Thanks for the help Kim

Hello I have a datagrid wit cellvalidating. When I enter an incorrect value the small red error icon show on the left of the grid. But when I correct the value and tab to the next cell the icon remains. How do I get reid of it? Thanks for the help Kim

Sorwen - Then I must be in my first year of Tek-Tips U. And I agree that everyone that has help me on this site has been great. Although I'm sure I've frustrated a few with my lack of knowledge. Because only having experience as a cobol mainframer - and then being dropped into this OOP and...

Thanks for that tip. Thanks for the help Kim

River Guy - Ok thank you - that was what I was looking for. I thought you could/should only put error checking within a validation routine when a field was changed or selected. It was just the approach I needed to understand. Sorwen - thanks for the info on collections - when I first started...

No I'm not talking about the totals I understand how the validation was done with a handler attached to one field when it changes. ie the hours field gets modified and it goes to the hour field validation. So with the reason code if it changes it needs to go to the reason code validation. But...

Maybe Do I set up another Ctype to get the index of sender and then use the name of the txtbox with that sent index in the if statement Thanks for the help Kim

Yes but in the case of what I want to do - I have the addhandler if there is a change to the reason combobox and then it gets sent into the validation routine. But how do I send the right textbox with the hours into the subroutine so I can check it? Thanks for the help Kim

Thank you - I'm not sure what is going on either. I thought maybe something got mixed up so I took out the autocomplete and it worked ok. But tried puting it back and got the same results. So I guess I won't be giving the users this option Thanks for all the help Thanks for the help Kim

I think I understand the addhandler I have set one up already to validate the hours. Below is the code and it works. I think maybe it's the cast(CType) and/or sender I don't quite understand. AddHandler Me.txtAdjHour1(x).Validating, AddressOf txtAdjHours_Validating AddHandler...

That didn't seem to make a difference - I first just commented out the if statement because I do have that code in all 3 comboboxes and that really made sense that that is what it could be. ''If drv Is Nothing Then '' Exit Sub ''End If but that made no difference So I...

So you mean one handler to take care of txthours1(x) , cbominutes1(x), cboreason1(x) one to take care of txthours2(x) , cbominutes2(x), cboreason2(x) and another to take care of txthours3(x) , cbominutes3(x), cboreason3(x) If this is what you meant I still not sure how to connect/validate...

Basically the first one; an array with one textbox and two comboboxes. But I do have three lines of this within the array. So I have an array 14 in length - looks like this: txthours1(x) , cbominutes1(x), cboreason1(x) txthours2(x) , cbominutes2(x), cboreason2(x) txthours3(x) ...

Hello Could I get some direction. I created array of controls. There is an hour textbox, minute combobox and a reason combo box. I have created handlers and validation for the hour textbox. Works ok But now I need to validate a hour,minute and reason combination. Not quite sure how this works...

Also for more info just in case it is helpful. I have the code; If drv Is Nothing Then Exit Sub End If The reason it is there is because when I tried to close the window it would drop thru the subroutine before exiting causing an error - I submitted this post and riverguy...

Actually I gave some false info in the last post. When I enter CAT it does go thru the routine twice as well - it just doesn't isn't locked so the message didn't come up. Thanks for the help Kim