G
Guest
How can I program Access 2003's File > Backup to either a button or as a
Switchboard item?
Switchboard item?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Shaun
runcommand acCmdBackup
G
Guest
I tried that, I added a new Switchboard Item of Run Code > runcommand
acCmdBackup. When I click the switchboard item I get "There was an error
running commad."
I also had tried it as a VB statement and could quite figure it out.
Am I doing it wrong?
acCmdBackup. When I click the switchboard item I get "There was an error
running commad."
I also had tried it as a VB statement and could quite figure it out.
Am I doing it wrong?
G
Guest
The syntax would be...
DoCmd.RunCommand acCmdbackup
However, here is an alternative.
Private Sub Back_up_Click()
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Back Up Database..."). _
accDoDefaultAction
End Sub
DoCmd.RunCommand acCmdbackup
However, here is an alternative.
Private Sub Back_up_Click()
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Back Up Database..."). _
accDoDefaultAction
End Sub
E
Edward
Awesome! Worked beautifully. What do the ". _" things do?
B
Bob
Normally, all those lines would have to be on one line like
CommandBars("Menu Bar").Controls("Tools").Controls("Datab...
<space> <underscore> lets you put each part on a new line. Its
cleaner.
CommandBars("Menu Bar").Controls("Tools").Controls("Datab...
<space> <underscore> lets you put each part on a new line. Its
cleaner.