Error 2046 The command or action 'AddFromOutlook' isn't available

[dixie617]

I have searched all over the internet and still have not figured out why once I split my database that the AddFromOutlook command will no longer work. All I have seen is that it has something to do with the linked tables. Any ideas???

Code:

Private Sub cmdAddFromOutlook_Click()
DoCmd.RunCommand acCmdAddFromOutlook
End Sub

Thanks

Christine

 

[MajP]

Run commands are basically executing menu items. There are times when menu items are greyed out. If you try to execute the coresponding run command it will not be available. Example. Go to the create tab and select a table. The menu choice to create a form from the table is active. Now select a module, the "create form" is greyed out because you can not create a form from a module. The corresponding run command will also not be available. So 90% of the time it is a focus issue or a state issue. You may have to set the focus to a control or open/close a form. Dialog forms are the biggest culprit. Because a lot of menu choices will not be available. You may want to use automation to control this better.

 

[dixie617]

Thanks for the information MajP, that was not it though. I discovered that some of the ac commands will not function on a linked table, they will only work on a table actually stored within the database currently in use. I had to import the linked table to get this function to work correctly.

Thanks

Christine