Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. evoluder

    Free Grid Control?

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

    Datagrid Validation

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

    Datagrid Validation

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

    Datagrid Validation

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

    Datagrid Validation

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

    Centering ListBox Selection

    Thanks, I'll give that a shot.
  7. evoluder

    Centering ListBox Selection

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

    SSTab still giving me trouble

    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_...
  9. evoluder

    DataGrid Row Lock

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

    DataGrid Row Lock

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

    SQL question that is tough concerning multiple fields in a table

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

    Calling sub or module to bind txt boxes on frmMain to ADO Recordset

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

    Calling sub or module to bind txt boxes on frmMain to ADO Recordset

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

    Calling sub or module to bind txt boxes on frmMain to ADO Recordset

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

    Access Relationships and ADO Bound Controls

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

    Access Relationships and ADO Bound Controls

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

    Access Relationships and ADO Bound Controls

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

    Access Relationships and ADO Bound Controls

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

    SSTab and Controlling Tab Order for Controls

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

    Multiple Outer Joins in Access

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

Part and Inventory Search

Back
Top