VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form frm_xqinfosc 
   Caption         =   "小區信息生成"
   ClientHeight    =   2835
   ClientLeft      =   3135
   ClientTop       =   2550
   ClientWidth     =   4665
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2835
   ScaleWidth      =   4665
   StartUpPosition =   1  '所有者中心
   Begin VB.Frame Frame1 
      Caption         =   "選擇生成區域數量"
      Height          =   2415
      Left            =   210
      TabIndex        =   0
      Top             =   210
      Width           =   4200
      Begin VB.Frame Frame3 
         Height          =   720
         Left            =   225
         TabIndex        =   8
         Top             =   1380
         Width           =   3750
         Begin VB.CommandButton Command2 
            Caption         =   "返回主系統"
            Height          =   405
            Left            =   2025
            TabIndex        =   10
            Top             =   180
            Width           =   1200
         End
         Begin VB.CommandButton Command1 
            Caption         =   "開始生成"
            Height          =   420
            Left            =   345
            TabIndex        =   9
            Top             =   180
            Width           =   1305
         End
      End
      Begin VB.Frame Frame2 
         Height          =   960
         Left            =   225
         TabIndex        =   1
         Top             =   270
         Width           =   3750
         Begin MSComCtl2.UpDown UpDown2 
            Height          =   300
            Left            =   3151
            TabIndex        =   2
            Top             =   375
            Width           =   240
            _ExtentX        =   423
            _ExtentY        =   529
            _Version        =   393216
            Value           =   1
            BuddyControl    =   "Text2"
            BuddyDispid     =   196615
            OrigLeft        =   3375
            OrigTop         =   360
            OrigRight       =   3615
            OrigBottom      =   660
            Max             =   1000
            Min             =   1
            SyncBuddy       =   -1  'True
            BuddyProperty   =   65547
            Enabled         =   -1  'True
         End
         Begin MSComCtl2.UpDown UpDown1 
            Height          =   300
            Left            =   1920
            TabIndex        =   4
            Top             =   375
            Width           =   240
            _ExtentX        =   423
            _ExtentY        =   529
            _Version        =   393216
            Value           =   1
            BuddyControl    =   "Text1"
            BuddyDispid     =   196614
            OrigLeft        =   1905
            OrigTop         =   360
            OrigRight       =   2145
            OrigBottom      =   660
            Max             =   1000
            Min             =   1
            SyncBuddy       =   -1  'True
            BuddyProperty   =   65547
            Enabled         =   -1  'True
         End
         Begin VB.TextBox Text1 
            Height          =   300
            Left            =   975
            TabIndex        =   5
            Top             =   375
            Width           =   945
         End
         Begin VB.TextBox Text2 
            Height          =   300
            Left            =   2445
            TabIndex        =   3
            Top             =   375
            Width           =   705
         End
         Begin VB.Label Label1 
            AutoSize        =   -1  'True
            Caption         =   "小區編號："
            Height          =   180
            Left            =   75
            TabIndex        =   7
            Top             =   435
            Width           =   900
         End
         Begin VB.Label Label2 
            AutoSize        =   -1  'True
            Caption         =   "至"
            Height          =   180
            Left            =   2220
            TabIndex        =   6
            Top             =   420
            Width           =   180
         End
      End
   End
   Begin VB.Label Label3 
      Caption         =   "Label3"
      Height          =   480
      Left            =   900
      TabIndex        =   11
      Top             =   3915
      Width           =   1605
   End
End
Attribute VB_Name = "frm_xqinfosc"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim i As Integer
Private Sub Command1_Click()
  For i = Val(Text1.Text) To Val(Text2.Text)
      adors.Open "select * from tab_xqinfo where 小區編號='" + Trim(Str(i)) + "'", cn, adOpenKeyset, adLockOptimistic
      With adors
          If .RecordCount = 0 Then
             Set adors = cn.Execute("insert into tab_xqinfo (小區編號) values('" & Trim(Str(i)) & "')")
          Else
             MsgBox i & "小區已存在！"
             adors.Close
          End If
      End With
  Next i
End Sub
Private Sub Command2_Click()
  Load Frm_main
  Frm_main.Show
  Unload Me
End Sub