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!

  • Congratulations Chris 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. hafa2000

    DLookup for 2 tables

    Hi Dhookom, I think I got myself confused here as well, I have a datasheet subform with a field called "SpecNo" and a field called "Consignor" and " Scheduled Agreement". On the AfterUpate event on the field "SpecNo" I want to code to lookup and get data from 2 tables using Me!SpecNo as the...
  2. hafa2000

    DLookup for 2 tables

    Hi, Hoping to get some assistance here. I have a DLookup code below that works fine for retrieving information, "CENTRE" from a table called "CodeLook", Private Sub SpecNo_AfterUpdate() On Error GoTo Err_SpecNo_AfterUpdate Dim strFilter As String Dim strFilter1 As String Dim FoundConsigneeID...
  3. hafa2000

    SQL INNER JOIN

    Hi PHV, Thanks so much for the reply. I don't know why I didn't see it missing in the INSERT Statement - worked like a charm!!
  4. hafa2000

    SQL INNER JOIN

    Hi, I have a form with 3 unbound text boxes: txtJob txtSpec txtConsignorName The form allows a user to search on one or more Job number or Spec number. The user can enter the numbers in the txtJob field or txtSpec field to search for Job numbers or Spec numbers which begin with those numbers...
  5. hafa2000

    Tab Control and Datagrid

    Hi Ousoonerjoe, Each tab has it's own grid but it is not showing up. Only the DGV on the first tab is shown by default when the form loads. When I click on tab2 or tab3 the DGV is not showing up, yet it's their in design time.
  6. hafa2000

    Tab Control and Datagrid

    Hi David, Actually no I'm not. I am still trying to get my feet wet with VB.Net. Let me know if the Tab enter/leave events work for showing the DGV on the other tabs? Thanks
  7. hafa2000

    Tab Control and Datagrid

    Hello, I'm new to VB.NET (coming from Microsoft Access), so any help here is greatly appreciated! I have a simple vb.net project with a form, dbSource, DataSet, BindingSource and TableAdapter. Project uses a Microsoft Access db with a 4 tables; tblJobs with a 1:M relationship with tblDelivery...

Part and Inventory Search

Back
Top