home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Programming Tool Box
/
SIMS_2.iso
/
bp_6_93
/
vbwin
/
vbaccess
/
frmmain.frm
< prev
next >
Wrap
Text File
|
1995-02-26
|
4KB
|
155 lines
VERSION 2.00
Begin Form frmMain
BackColor = &H00C0C0C0&
BorderStyle = 3 'Fixed Double
Caption = "BP Professionell Demo"
ClientHeight = 4830
ClientLeft = 2340
ClientTop = 2445
ClientWidth = 7365
Height = 5520
Icon = FRMMAIN.FRX:0000
Left = 2280
LinkTopic = "Form1"
ScaleHeight = 4830
ScaleWidth = 7365
Top = 1815
Width = 7485
Begin Menu mnuFile
Caption = "&File"
Begin Menu mnuFileDelete
Caption = "&L÷sch Demo"
End
Begin Menu mnuFileEnd
Caption = "&Beenden"
End
End
Begin Menu mnuReorg
Caption = "&Reorganisation"
Begin Menu mnuReorgKomp
Caption = "&Verdichten"
End
Begin Menu mnuReorgRep
Caption = "&Reparatur"
End
End
Begin Menu mnuAbout
Caption = "&▄ber"
Begin Menu mnuAboutInfo
Caption = "&Info"
End
End
End
Option Explicit
Sub Form_Load ()
Dim sPfad As String
Dim sNewFile As String
Dim sOldFile As String
Dim sMitFile As String
'wie hei▀t meine Datenbank (Fⁿr Komprimierung)
sMdb_pur = "KdTest"
' wo ist meine Applikation
sPfad = app.Path + "\"
'wie hei▀t die Datenbank
sMdb = sPfad + sMdb_pur + ".mdb"
'auf das Laufwerk und in den Pfad wechseln
ChDrive Left$(sPfad, 2)
ChDir Left$(sPfad, Len(sPfad) - 1)
Set db1 = OpenDatabase(sMdb)
NL = Chr$(10) + Chr$(13)
Datum = Mid$(Date$, 4, 2) + "." + Left$(Date$, 2) + "." + Right$(Date$, 2)
CenterForm Me
Exit Sub
'######################################################################
'Um nachstehende Funktion zu aktivieren, bitte zuerst Vorbereitungen
'wie in Artikel BP-Professionel 4/94 beschrieben, treffen.
'danach EXIT sub entfernen
'iVersion = 1 'Stand vom 01.9.94
iVersion = 2 'Stand vom 20.9.94
If MdbCheck() = True Then
'Umbenennen und tabellenschieben...
db1.Close
'÷ffnen mit exclusivem Zugriff
Set db1 = OpenDatabase(sMdb, True)
db1.Close
sNewFile = sMdb
sOldFile = sPfad + sMdb_pur + ".old"
sMitFile = sPfad + sMdb_pur + ".new"
On Error GoTo RenameErrorhandler
'altes File l÷schen wenn vorhanden
Kill sOldFile
'vorhandene Datenbank .mdb umbenennen in .old
Name sNewFile As sOldFile
'neue mitgelieferte Datenbank [.NEW] umbenennen
Name sMitFile As sNewFile
frmUpdate.Show MODAL
Set frmUpdate = Nothing
'...alles upgedatet.. open Database
Set db1 = OpenDatabase(sMdb)
'open Table
Set db1 = OpenDatabase("Settings")
tSettings.Edit
tSettings!MdbVersion = iVersion
tSettings.Update
tSettings.Close
Screen.MousePointer = Default
Exit Sub
End If
Exit Sub
RenameErrorhandler:
If Err = ERR_FILENOTFOUND Then 'File not found
Resume Next
End If
Resume Next
End Sub
Sub Form_Unload (Cancel As Integer)
'nicht vergessen, die Datenbank zu schlie▀en...
db1.Close
Set db1 = Nothing
End
End Sub
Sub mnuAboutInfo_Click ()
frmIntro1.Show 1
End Sub
Sub mnuFileDelete_Click ()
frmKunde.Show MODAL
End Sub
Sub mnuFileEnd_Click ()
Unload Me
End Sub
Sub mnuReorgKomp_Click ()
Dim iRet As Integer
iRet = mdbVerdichten()
End Sub
Sub mnuReorgRep_Click ()
Screen.MousePointer = Hourglass
db1.Close
Load frmInfo
frmInfo.Tag = INFO_REPAIR
frmInfo.Show MODAL
Set frmInfo = Nothing
Set db1 = OpenDatabase(sMdb)
Screen.MousePointer = Default
End Sub