Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2008
    All over, Now in Missouri

    Unanswered: Selecting Tables In Access

    I am using the Median Form/Code from Microsoft to get my Median stats. The Code Selects all the Tables from my Access DB which is ok, but I want it to select only tables that start with "Median".

    How do I change this code to look at the Tables and only return those meeting "Median*"?

    Private Sub Form_Load()
    ' Fill the list of tables.
    Dim tdf As TableDef
    cboTable.RowSourceType = "Value List"
    For Each tdf In CurrentDb.TableDefs
    If Not (tdf.Attributes And dbSystemObject) <> 0 Then
    If Left$(tdf.Name, 4) <> "~tmp" Then
    cboTable.AddItem tdf.Name
    End If
    End If
    Next tdf
    End Sub

    We tend to look at Linear paths which can lead us to a path of resistance!

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    which version of VB?
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts