Compacting with SENDKEYS "%TDC" doesnt work....

homer2002

Registered User.
Local time
Today, 17:18
Joined
Aug 27, 2002
Messages
152
Hi

On the database I am coding up at the moment, I need a compact Database button.

Simple as it sounds, the ol' SENDKEYS trick won't work for me, cause on "Tools...Startup" I have all the menu's switched off.
Obviously now Sendkeys just makes a couple of feeble beeps.

Is there another way to do this or can I do it like this


1. Turn the menus Back on
2. Perform SendKeys
3. Turn menus off again?


Any help would be appritiated :0)
 
Why even use SendKeys?

You have the Docmd.RunCommand available to you:

Code:
DoCmd.RunCommand acCmdCompactDatabase
DoCmd.RunCommand acCmdRepairDatabase
 

Users who are viewing this thread

Back
Top Bottom