Private Sub Form_Load()
Dim slashPositionInteger As Integer
LoadResStrings Me
Me.Left = GetSetting(App.Title, "Settings", "MainLeft", 1000)
Me.Top = GetSetting(App.Title, "Settings", "MainTop", 1000)
Me.Width = GetSetting(App.Title, "Settings", "MainWidth", 6500)
Me.Height = GetSetting(App.Title, "Settings", "MainHeight", 6500)
slashPositionInteger = InStrRev(InputFile, "\")
If slashPositionInteger > 0 Then
previousOrdersFolderName = Left(InputFile, slashPositionInteger)
Else
previousOrdersFolderName = InputFile
End If
MSHFlexGrid1.ColHeaderCaption(0, 0) = "File Name"
MSHFlexGrid1.ColHeaderCaption(0, 1) = "File Date"
MSHFlexGrid1.ColHeaderCaption(0, 2) = "File Size"
MSHFlexGrid1.ColHeaderCaption(1, 0) = "_________"
MSHFlexGrid1.ColHeaderCaption(1, 1) = "File Date"
MSHFlexGrid1.ColHeaderCaption(1, 2) = "File Size"
MSHFlexGrid1.Cols = 3
MSHFlexGrid1.ColWidth(0) = 1600
MSHFlexGrid1.ColWidth(1) = 2800
MSHFlexGrid1.ColWidth(2) = 1100
MSHFlexGrid1.ColAlignmentHeader(0, 0) = flexAlignCenterBottom
MSHFlexGrid1.ColAlignmentHeader(0, 1) = flexAlignCenterCenter
MSHFlexGrid1.ColAlignmentHeader(0, 2) = flexAlignRightBottom
MSHFlexGrid1.ColAlignment(2) = flexAlignRightBottom
MSHFlexGrid1.SelectionMode = flexSelectionByRow
MSHFlexGrid1.BorderStyle = flexBorderNone
MSHFlexGrid1.HighLight = flexHighlightAlways
MSHFlexGrid1.BackColor = backgroundColorSchemeConstant
MSHFlexGrid1.BackColorBkg = backgroundColorSchemeConstant
MSHFlexGrid1.BackColorUnpopulated = backgroundColorSchemeConstant
MSHFlexGrid1.BackColorFixed = &H80FF&
MSHFlexGrid1.ForeColorFixed = &H1969E9
MSHFlexGrid1.FontSize = 10
MSHFlexGrid1.Font.Bold = True
MSHFlexGrid1.FixedRows = 0
MSHFlexGrid1.FontFixed.Bold = True
MSHFlexGrid1.ColHeader(0) = flexColHeaderOn
Set previousOrdersFileSystemObject = New FileSystemObject
Set previousOrdersFolder = previousOrdersFileSystemObject.GetFolder(previousOrdersFolderName)
Set previousOrdersFiles = previousOrdersFolder.Files
Dim i As Integer
i = 0
Dim previousOrdersConnection As New ADODB.Connection
Dim previousOrdersRecordSet As New ADODB.Recordset
previousOrdersRecordSet.CursorLocation = adUseClient
previousOrdersRecordSet.Fields.Append "FileName", adChar, 12, adFldIsNullable
previousOrdersRecordSet.Fields.Append "FileDate", adDate, 16, adFldIsNullable
previousOrdersRecordSet.Fields.Append "FileSize", adChar, 12, adFldIsNullable
previousOrdersRecordSet.Open , , adOpenStatic, adLockBatchOptimistic
For Each previousOrdersFileName In previousOrdersFiles
If LCase(Mid(previousOrdersFileName.Name, 1, 6)) = "orders" Then
If (Mid(previousOrdersFileName.Name, 8, 3) >= "001" And Mid(previousOrdersFileName.Name, 8, 3) <= "030") Or LCase(Mid(previousOrdersFileName.Name, 8, 3)) = "bol" Then
previousOrdersRecordSet.AddNew
Set previousOrdersFile = previousOrdersFileSystemObject.GetFile(previousOrdersFileName)
previousOrdersRecordSet!FileName = Format(previousOrdersFileName.Name, "<")
previousOrdersRecordSet!FileDate = previousOrdersFile.DateLastModified
previousOrdersRecordSet!FileSize = Format(previousOrdersFile.Size, "###,###,##0")
previousOrdersRecordSet!FileSize = Format(previousOrdersRecordSet!FileSize, ">")
i = i + 1
End If
End If
Next
previousOrdersRecordSet.MoveFirst
Set MSHFlexGrid1.DataSource = previousOrdersRecordSet
MSHFlexGrid1.RowSel = 1
Me.Text1.FontSize = 24
Me.Text1.FontBold = True
Me.Text1.ForeColor = &H80FF&
Me.Text1.BackColor = backgroundColorSchemeConstant
End Sub