In the OnClick event of your command button put this
Call AutoCompact
"AJOLSON" wrote:
[Quoted Text] > I have the following function that I want to execute onclidk using a command
> button.
> What code will run this (or any function) on click within a command button
> Public Function AutoCompact()
>
> CommandBars("Menu Bar"). _
> Controls("Tools"). _
> Controls("Database utilities"). _
> Controls("Compact and repair database..."). _
> accDoDefaultAction
>
> End Function
>
> Thanks
>
>
|