Hi all
Have a split database and would like to back up both parts from a command button on a front-end menu form.
I can use a simple command like this for the front-end
If MsgBox("Do you want to back up the database?", vbYesNo + vbQuestion + vbDefaultButton2) = vbYes Then
CommandBars("Menu Bar").Controls("Tools").Controls("Database utilities").Controls("Back up database...").accDoDefaultAction
End If
This is not too elegant and I'd prefer it to name the file automatically, adding a date-stamp. Then do the more important back end.
Have a split database and would like to back up both parts from a command button on a front-end menu form.
I can use a simple command like this for the front-end
If MsgBox("Do you want to back up the database?", vbYesNo + vbQuestion + vbDefaultButton2) = vbYes Then
CommandBars("Menu Bar").Controls("Tools").Controls("Database utilities").Controls("Back up database...").accDoDefaultAction
End If
This is not too elegant and I'd prefer it to name the file automatically, adding a date-stamp. Then do the more important back end.