Launching menu command from code

[roypython]

Hello.
Your help is very much appreciated.
I want to launch the "partial replica wizard" from code.
Can it be done?
(It is located in Tools -> Replication ->partial replica wizard

Thank you.
Cheers
Roy

 

[boblarson]

Look into using DoCmd.RunCommand as that will give you almost every menu command available on the menus:

DoCmd.RunCommand acCmdPartialReplicaWizard

 

[roypython]

Thank you very much!

 

[dfenton]

Look into using DoCmd.RunCommand as that will give you almost every menu command available on the menus:

DoCmd.RunCommand acCmdPartialReplicaWizard

Two points:

1. The Access help for RunCommand recommends using Application.RunCommand instead.

2. This is a version-specific command that did not exist until Access 2002.

--
David W. Fenton
David Fenton Associates
http://dfenton.com/DFA/

 

[boblarson]

2. This is a version-specific command that did not exist until Access 2002.

The Application.RunCommand maybe, but the

DoCmd.RunCommand acCmdPartialReplicaWizard

exists in Access 2000.

 

[dfenton]

The Application.RunCommand maybe, but the

DoCmd.RunCommand acCmdPartialReplicaWizard

exists in Access 2000.

You're right -- the acCmdPartialReplicaWizard constant is defined as 524. I just couldn't get it to work in A2K for some reason. Thanks for the correction.

It created by Michael Kaplan for A2K, and did not exist before that.

--
David W. Fenton
David Fenton Associates
http://dfenton.com/DFA/