Search results for query: *

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...

I messed up. I need to clarify: In my first example, the clothes types were field Names rather than values. So each row would simply be numbers. I am having trouble selecting multiple color values for the row. Example tbl: Column Headings: ClothesID Jacket Shirt Pants Field Values...

What you are saying is true. The issue I am confused about is how do I build my ADO recordset in such a way that I display: 1 Jacket Black 2 Shirt Black 3 Pants Yellow Rather than displaying the IDs: 1 1 2 2 2 2 3 3 3 Does that make sense? Thanks.

Hello, I am setting up a datagrid in a Vb6 application, its datasource is an ADO recordset that I am creating from a SQL query. For example, consider the following table layout in an Access database: tblClothes ClothesID: 1 Jacket: 2 Pants: 3 Shirt: 2 ClothesID: 2 Jacket: 1 Pants: 2...

Hello, I have a SSTab control on a form. There are three tabs, each tab contains multiple textboxes, checkboxes, and comboboxes. I am using a code snippet provided in a VB6 book to prevent the focus moving off of the current SSTab.Tab if the user tabs through the input controls. The code is...

It works as you both describe. Why can't Access do it like everybody else? Thanks for the help!