Search results for query: *

Thanks much dilettante for the link and your suggestion. this is a very good link, you're right, i'll have to read it more in much detail. thanks again.

oh, okay, thanks Tracy tsdragon. let me try that. thanks so much.

Thanks AndyLee100 for your code. as I can see there are several ways to try to catch errors, so it is helpful and valuable to see them from you all and try them in my application. thanks so much.

Thanks chiph very much for your input and code. I will try your method too, it seems to be a very good idea.

Hi, i have the blocks of code below, and I'm not sure what I do wrong, but i want to be able to click on the navigation button to move through the record, but it also will highligh on the grid for that same record navigated. The code below seems to work but it will highlight 2 rows at the same...

oh, okay, i understand now. thank you all for your input. i really appreciate your help.

Hi, Does anyone knows when to code this On Error GoTo code...? I want to do it right, but I'm confused when/where to code the error code so when there's an error it knows what to do...so, do you code it in ALL sub routines and functions, or just on certain one? I read a few books, but they...

Thanks much DrJavaJoe and CaptainD for valuable inputs.

Thanks much pms18066 for your input. the database is sitting on the server, so as you stated, stored procedure would be faster in execution.

hi, when i need to get a recordset, I either write a select sql statement directly in vb or have it to call a stored procedure. Which method is better, more efficient, or faster? any input would be appreciated. thanks much.

Thanks tsdryden, I will try your way. thanks much for helping me.

thanks zemp, i will look around too to see if i can find any solution to this problem. thanks much for your extra effort.

Okay, I have changed the cmdNavigate_Click() procedure as zemp suggested above, it works, but the text on the row of the flexgrid is not highlighed as I clicked on the navigation buttons. also, when I clicked on the last navigation button, it would go to the last row which is always empty...

Thank zemp, i think you got something there, so let me try. thanks so much for helping me. i'm impressed that you understand what I am trying to explain.

Hi, Does anyone knows how to combine navigation command buttons with Flexgrid (i'm not sure if I state this correctly), but the idea is if the user clicked on first, or prev, or next or last buttons, then the record also moved accordingly on the flexgrid. am I making any sense? any input...

Thanks Golom, you're right. thanks for your input.

Never mind, i just got it. thank you.

Hi, I'm trying to create an insert sql statement in a form in vb6. the insert statement works for rest but not for the column where its the value is: Insurance Company. I tried insert.... '" & [Insurance Company] & "'," .... but it keeps gives error message of Type Mismatch. what is wrong...

never mind, i got it.

Hi, I have the code below. everything else seems to work fine, except when it comes to the check box. it would stop at the check box and error as type mismatch. what is wrong with my code? any input would be greatly appreciated. private sub flexgrid_click() Dim i As Integer Dim x As...