Link to home
Create AccountLog in
Avatar of joeserrone
joeserrone

asked on

Compact and Repair button

Hello,
I have a MS Access 2003 database and added the following code to the btnCompact button, I wanted to see if I can "dress this up a bit" by maybe adding some sort of progress bar or something that will appear on the screen and let the user know that the compat and repair function is running. I know there is a progress bar usually on the bottom left corner but I've seen users simply click out of the database or shut down abruptly their PC thinking the process was done!
Any suggestions????
Private Sub btnCompact_Click()

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

End Sub

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account