Comments by Ivan_FM - CodeProject

Ivan_FM 16-Apr-16 5:08am View

Really thanks for sharing you knowledge OrignalGriff!

Ivan_FM 11-Apr-16 7:24am View

Ok, try this again. I've just tried it right now and Works fine.

Private Sub TextBox1_KeyDown(sender As Object, e As KeyEventArgs) Handles TextBox1.KeyDown
Select Case e.KeyCode
Case Keys.Enter
e.SuppressKeyPress = True
End Select
End Sub

Because the textbox has multiline=false, you can supress this key and there's no problem. Also you can convert the "Enter" kepress to a "TAB" adding it to the case if you want.

Ivan_FM 11-Apr-16 5:03am View

Yes, I've been working with this, changing all in order to work only with one procedure. Really more optimized, also in the app code! ;) It's really a better way to do it. Thanks!

Ivan_FM 10-Apr-16 12:53pm View

Ok OriginalGriff, I've tried it and Works fine. Realy great! ;)

But there's one question... when i do this in two separate procedures i can see easilly from where the issues comes. If i do INSERT and UPDATE with the same procedure, how can i know wich part have the issue?

Ivan_FM 10-Apr-16 7:54am View

The "IF @@ROWCOUNT = 0" Works like the "if exist"? Wow, nice point! I will use this in order to use only one stored procedure to insert and update rows. I will try it now, thanks!!

Ivan_FM 9-Apr-16 13:52pm View

How you poppulate the datagrid? can you give us some code?

Ivan_FM 8-Apr-16 15:06pm View

Ok, keep on trying and learning ;)

Have a great day too!

Ivan_FM 8-Apr-16 14:56pm View

Try this:

Select Case cbDroppedEarly.Selecteditem.ToString
Case "YES"
tbLinehaulPaid.BackColor = Color.Teal
tbFuelSurchargePaid.BackColor = Color.Teal
Case Else
tbLinehaulPaid.BackColor = Color.WhiteSmoke
tbFuelSurchargePaid.BackColor = Color.WhiteSmoke
End Select

Ivan_FM 8-Apr-16 14:41pm View

;)

Ivan_FM 8-Apr-16 14:36pm View

No problem. Take a look here TextBox Events (System.Windows.Forms)[^]

I think the problem is in the event. Try this again.

Private Sub cbDroppedEarly_SelectedIndexChanged(ByVal sender as Object, ByVal e As EventArgs) handles cbDroppedEarly.SelectedIndexChanged
Select Case cbDroppedEarly.Selecteditem.ToString
Case "YES" : tbLinehaulPaid.BackColor = Color.Teal
Case Else : tbLinehaulPaid.BackColor = Color.WhiteSmoke
End Select
End Sub

Note the "handles cbDroppedEarly.SelectedIndexChanged". This links the event to the textbox.

Ivan_FM 8-Apr-16 14:16pm View

Agree with the previous comments, and let me add one more thing.

Avoid the "dim" inside a for-next statement, it will save a lot of time of response.

Ivan_FM 8-Apr-16 14:02pm View

If you say that still not working... mmm... then, Make sure that you are using properly the event "cbDroppedEarly.selctedindexchanged". Take a look at the control events, maybe the link between the code and the control has broken.

Ivan_FM 8-Apr-16 13:59pm View

I've updated the solution, take a look

Ivan_FM 8-Apr-16 13:56pm View

Please, leave the comments at the solution.

Ivan_FM 8-Apr-16 11:14am View

Thanks, i realy don't know what was thinking about.... hope it's friday ;)

Ivan_FM 4-Apr-16 10:57am View

ok! That's a good point, I will try it and then I will tell us how it goes ;)

Ivan_FM 13-Feb-16 7:09am View

You have gived an unique name to the textbox when create it... then, use this name as a referal.

Hint: Use more específic name, in exemple, giving an optional parameter throw the function that adds the textbox name when you call it.

Ivan_FM 13-Feb-16 5:53am View

Yes, sure it was a connection issue.

Until you provide the full error message, check it out too ;)
Runtime Error 3709 while accesing SQL database in VB6 - Stack Overflow[^]

Ivan_FM 13-Feb-16 5:48am View

Thanks! it's a good point about SQL injection.

Comments by Ivan_FM (Top 19 by date)