Compact And Repair

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Is there a way I can put a compact and repair button on my main menu
Thanks in advance.........Bob Vance
 
Thanks, hoe do I make a button run this code? Bob
Public Sub CompactDB()

CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
accDoDefaultAction

End Sub
 
Got It Thanks...Bob

Bob said:
Thanks, hoe do I make a button run this code? Bob
Public Sub CompactDB()

CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
accDoDefaultAction

End Sub
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Anything wrong with using this code to Quit? 2
Compact and Repair 12
Compact & Repair 4
Compact and Repair – Status? Date/Time Stamp? 2
Compact and Repair - creates new file 9
Compact and Repair Advice 14
Compact and Repair a Database 2
Compact and Repair Database? 4

Back
Top