frmyellow.frm

Online Telephone Directory in Visual Basic

VERSION 5.00
Begin VB.Form Form11 
   BackColor       =   &H00C0FFFF&
   BorderStyle     =   0  'None
   Caption         =   "Form11"
   ClientHeight    =   9225
   ClientLeft      =   0
   ClientTop       =   -105
   ClientWidth     =   14085
   LinkTopic       =   "Form11"
   ScaleHeight     =   9225
   ScaleWidth      =   14085
   ShowInTaskbar   =   0   'False
   StartUpPosition =   3  'Windows Default
   WindowState     =   2  'Maximized
   Begin VB.Timer Timer1 
      Interval        =   1000
      Left            =   360
      Top             =   1680
   End
   Begin VB.CommandButton Command10 
      BackColor       =   &H00C0E0FF&
      Caption         =   "Home"
      BeginProperty Font 
         Name            =   "Times New Roman"
         Size            =   9.75
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   615
      Left            =   13440
      Picture         =   "FrmYellow.frx":0000
      Style           =   1  'Graphical
      TabIndex        =   0
      Top             =   9960
      Width           =   1575
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "Yellow Pages"
      BeginProperty Font 
         Name            =   "Garamond"
         Size            =   18
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H0000FFFF&
      Height          =   405
      Left            =   1320
      TabIndex        =   2
      Top             =   600
      Width           =   2040
   End
   Begin VB.Shape Shape1 
      BackColor       =   &H00000000&
      BackStyle       =   1  'Opaque
      Height          =   1575
      Left            =   480
      Shape           =   2  'Oval
      Top             =   120
      Width           =   4335
   End
   Begin VB.Label Label2 
      BackColor       =   &H00C00000&
      BeginProperty Font 
         Name            =   "Times New Roman"
         Size            =   12
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00FFFFFF&
      Height          =   495
      Index           =   0
      Left            =   5520
      TabIndex        =   1
      Top             =   0
      Width           =   9495
   End
   Begin VB.Image Image1 
      Height          =   5970
      Left            =   360
      Picture         =   "FrmYellow.frx":29C12
      Top             =   2280
      Width           =   4515
   End
   Begin VB.Shape Shape2 
      BackColor       =   &H00E0E0E0&
      BackStyle       =   1  'Opaque
      BorderColor     =   &H00FFFFFF&
      Height          =   1575
      Left            =   240
      Shape           =   2  'Oval
      Top             =   480
      Width           =   4815
   End
End
Attribute VB_Name = "Form11"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim db As Database, rs As Recordset

Private Sub Command10_Click()
Unload Me
Form1.Show
End Sub

Private Sub Form_Activate()
Dim i As Integer
Set rs = db.OpenRecordset("Select Distinct(Category) from Yellow")
rs.MoveFirst
For i = 0 To rs.RecordCount - 1
Label2(i).Caption = rs(0)
Load Label2(i + 1)
Label2(i + 1).Visible = True
Label2(i + 1).Top = Label2(i).Top + Label2(i).Height
Label2(i + 1).Left = Label2(i).Left
rs.MoveNext
Next i

Label2(i).Visible = False

End Sub

Private Sub Form_Load()
Set db = OpenDatabase(App.Path & "\Database\DirDb.mdb")

End Sub

Private Sub Label2_Click(Index As Integer)

ca = Label2(Index).Caption
Unload Me
Form15.Show
End Sub

Private Sub Timer1_Timer()
For i = 0 To Label2.Count - 1
Label2(i).BackColor = RGB(Rnd * 255, Rnd * 255, Rnd * 255)
Next
End Sub