Recent content by evoluder

Hello, Does anyone know of a good, free grid control? The datagrid control included with VB6 has a bug that is preventing me from using it effectively (BeforeUpdate event not firing at inopportune times). I've looked at ComponentOne's True DB Grid and it rocks; however, it is overkill for...

1. ADO: 2.7, MDAC: 2.7 2. SP5, Yup. 3. Check out the following KB article on MSFT: Q288346 http://support.microsoft.com/default.aspx?scid=kb;en-us;Q288346 It specifically mentions the BeforeUpdate event but it is precisely the behavior I am seeing so I assume that the beforecolupdate event is...

CCLINT, I tried your suggestion, but what I am finding is that the Recordset events are not being called before the error occurs. The "Multiple-Step" error I wrote about above is being generated by the Datagrid control before the Recordset sees anything. On a cell value change that...

CCLINT, Thanks for the note, I'll give it a shot. I haven't played around with the recordset events much so I'll have to do some research. Cheers.

Hello everyone, I have a datagrid question I hope you can help me with. Let me explain: I have a datagrid that is bound to a client side ADO recordset. The user is required to press a toolbar button before she is able to edit cells in the datagrid. After pressing the toolbar button, all...

Thanks, I'll give that a shot.

Hello, Here is my scenario: I have a bound textbox for user input. When the user enters a new value and the control loses focus, the new value in the textbox is compared to an array of values. If the new value is not in the array, a form with a listbox pops up. The listbox on this form is...

Have you tried: Private Sub SSTab1_Click (Previous Tab As Integer) if sstab1.tab = 0 then Adodc1.RecordSource = "SELECT(*) FROM PupilResultsData_ WHERE Module = '1'" Adodc1.Refresh elseif sstab1.tab = 1 then Adodc.RecordSource = "SELECT(*) FROM PupilResultsData_...

Hello again, Anyone have any ideas on this? Thanks for any help.

Hello, I have a DataGrid that is bound to an ADO recordset. Above it on the same form, I have a series of bound text boxes (to the same ADO recordset). When the user hits a menu button such as "edit," the currently selected record in the datagrid is displayed in the bound text boxes...

I am not sure exactly what you are after but give the following a shot: ssql = "SELECT * FROM tblcustomer, tbltransaction WHERE (tbltransaction.TransactionId = " & lngtid & ") AND (tblcustomer.CustomerId = tbltransaction.CustomerId)" This would need to be all on one line or...

Thank you everyone. I figured out what the issue was. I had used the VB application wizard when I started this project to see what it could do. I've removed much of the code it inserted but I missed one piece, the formload module that did this: Public fMainForm As frmMain Sub Main() Set...

You are correct, I actually have it as you describe, I just failed to include it correctly in my post. The issue appears to be setting the properties of the controls on frmMain. If on form2 I put the following in the cmdOK_Click procedure: frmMain.txtBox.Text = "Test" I get no...

Hello, let me explain my problem. I have two forms. The first form contains text boxes and a datagrid that are bound controls to an ADO recordset. I want users to be able to pull up a second form that allows them to select an integer, hit "OK" and have all of the bound controls be...

I figured out how to get what I was after. The solution was simpler than I anticipated: SELECT ClothesID, (SELECT ColorName FROM tblColor WHERE tblColor.ColorID = tblClothes.Jacket) AS Jacket, (and so on...) FROM tblClothes, tblColor It seems to work correctly, hopefully I won't run into any...