Compact & Repair Button on form

[Ruegen]

I'd like a pop up form to have a compact and repair onlick action

what is the VBA to make this happen?

[June7]

Review https://www.accessforums.net/access/...xit-45876.html

Bing: Access vba compact repair
http://stackoverflow.com/questions/1...atabase-in-vba

[Ruegen]

Review https://www.accessforums.net/access/...xit-45876.html

Bing: Access vba compact repair
http://stackoverflow.com/questions/1...atabase-in-vba

Yeah I've tried those methods and the sendkeys one with no results - not this is the current database. As though you are clicking the compact & repair button (access 2010)

[Ruegen]

I figured it out

to anyone using Access 2010 - the vba is

Private Sub Command2_Click()


SendKeys ("%+(TDC)")


End Sub