CRETE A BACKUP FILE
Answer / haiipl25
Open a project which have one text box name as 'txtbackup' &
one command button name as 'cmdBackup'. After that, put the
following code for Back up the file which is present in that
current folder with the name sample.mdb
Dim obj As Object
Dim path As String
Dim j As Integer
Dim b As String
Dim a(100) As String
Dim i As Integer
If txtbackup <> "" Then
'******************************************
Dim c, c1 As String
i = 0
c = txtbackup.Text
For j = 1 To Len(c)
c1 = Mid(c, j, 1)
If c1 <> "\" Then
a(i) = a(i) & c1
Else
i = i + 1
End If
Next
'*******************************************
Set obj = CreateObject("Scripting.FileSystemObject")
path = txtbackup.Text
b = a(0)
'**** Folder Creation ****
Dim fso As New FileSystemObject
For j = 1 To i
b = b & "\" & a(j)
If Not fso.FolderExists(b) Then
obj.CreateFolder (b)
End If
Next
'**** File Creation ****
If Not fso.FileExists(path & "\sample_" & Format$(Date,
"dd_mm_yy") & ".mdb") Then
obj.CopyFile "" & App.path & "\sample.mdb", "" & path &
"\sample_" & Format$(Date, "dd_mm_yy") & ".mdb"
MsgBox "Data Base Successfuly Back Up in Loction :" & path
& " ", vbInformation, "Back Up"
Else
If MsgBox("Data Base is already exists. Do u want to
replace it?", vbQuestion + vbYesNo, "Confirmation") = vbYes Then
obj.CopyFile "" & App.path & "\sample.mdb", "" & path &
"\sample_" & Format$(Date, "dd_mm_yy") & ".mdb"
MsgBox "Data Base Successfuly Back Up in Loction :" & path
& " ", vbInformation, "Back Up"
End If
End If
Else
MsgBox "Enter the Destination Path.....", vbExclamation
End If
txtbackup.Text = ""
txtbackup.SetFocus
End Sub
Is This Answer Correct ? | 10 Yes | 0 No |
What is the difference between <F8> and <Shift-F8> when debugging?
advantage and disadvantage in visual-basic and ms-access please tell me or send my mail-id
Explain about creating VB applications in excel?
____ property of menu cannot be set at run time.
What is the difference between ANSI and UNICODE strings when passed as arguments to a DLL?
how many no of controls in form?
16 Answers AIMS, Airex Logistics,
How do you create a form in visual basic?
Explain OLE Drag and Drop.
How would you add elements and pictures to listitems in listview control?
Difference between Linked Object and Embedded Object?
What is the use of Active Control Property?
How does the following statements work? On Error Resume Next