access 2007 add contacts from outlook
in [General]
|
From: Gen on 21 Jan 2010 14:54 Hi, I created a contact management DB using 2003, then upgraded it to 2007. The 2007 version has a contact management template that has a handy macro which allows you to add contacts from outlook which I copied and pasted into my similar form. Works great in the template I downloaded, however once I put the button in my DB it doesn't work - the macro has remained in tact and I can see no links to DB-specific objects. I tried to create a new button with the same macro codes and still nothing. The macro is as follows: RunCommand: AddFromOutlook Pretty simple, but I get the error "The command or action "AddFromOutlook" isn't available right now". Why oh why is this button not working for me?!?!?
From: Arvin Meyer [MVP] on 21 Jan 2010 15:33 I would expect the command to read: DoCmd.RunCommand acCmdAddFromOutlook If indeed yours reads: RunCommand: AddFromOutlook It wouldn't run. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Gen" <Gen(a)discussions.microsoft.com> wrote in message news:FFE67979-ECAA-4F0E-A772-6B46FE29B074(a)microsoft.com... > Hi, > > I created a contact management DB using 2003, then upgraded it to 2007. > The > 2007 version has a contact management template that has a handy macro > which > allows you to add contacts from outlook which I copied and pasted into my > similar form. Works great in the template I downloaded, however once I > put > the button in my DB it doesn't work - the macro has remained in tact and I > can see no links to DB-specific objects. I tried to create a new button > with > the same macro codes and still nothing. The macro is as follows: > > RunCommand: AddFromOutlook > > Pretty simple, but I get the error "The command or action "AddFromOutlook" > isn't available right now". > > Why oh why is this button not working for me?!?!?
From: Gen on 24 Jan 2010 21:28 I put that command into the VBA code for the button and get runtime error 2046: The command or action 'AddFromOutlook' isn't available now. "Arvin Meyer [MVP]" wrote: > I would expect the command to read: > > DoCmd.RunCommand acCmdAddFromOutlook > > If indeed yours reads: > > RunCommand: AddFromOutlook > > It wouldn't run. > -- > Arvin Meyer, MCP, MVP > http://www.datastrat.com > http://www.mvps.org/access > http://www.accessmvp.com > > > "Gen" <Gen(a)discussions.microsoft.com> wrote in message > news:FFE67979-ECAA-4F0E-A772-6B46FE29B074(a)microsoft.com... > > Hi, > > > > I created a contact management DB using 2003, then upgraded it to 2007. > > The > > 2007 version has a contact management template that has a handy macro > > which > > allows you to add contacts from outlook which I copied and pasted into my > > similar form. Works great in the template I downloaded, however once I > > put > > the button in my DB it doesn't work - the macro has remained in tact and I > > can see no links to DB-specific objects. I tried to create a new button > > with > > the same macro codes and still nothing. The macro is as follows: > > > > RunCommand: AddFromOutlook > > > > Pretty simple, but I get the error "The command or action "AddFromOutlook" > > isn't available right now". > > > > Why oh why is this button not working for me?!?!? > > > . >
From: Arvin Meyer [MVP] on 28 Jan 2010 07:15 I'm not reproducing that problem. Once again, let me give you the exact syntax. Copy and paste it EXACTLY the way it appears in this post: DoCmd.RunCommand acCmdAddFromOutlook -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Gen" <Gen(a)discussions.microsoft.com> wrote in message news:16CB7088-F142-42B4-AB12-469AE8AFF547(a)microsoft.com... >I put that command into the VBA code for the button and get runtime error > 2046: The command or action 'AddFromOutlook' isn't available now. > > > > "Arvin Meyer [MVP]" wrote: > >> I would expect the command to read: >> >> DoCmd.RunCommand acCmdAddFromOutlook >> >> If indeed yours reads: >> >> RunCommand: AddFromOutlook >> >> It wouldn't run. >> -- >> Arvin Meyer, MCP, MVP >> http://www.datastrat.com >> http://www.mvps.org/access >> http://www.accessmvp.com >> >> >> "Gen" <Gen(a)discussions.microsoft.com> wrote in message >> news:FFE67979-ECAA-4F0E-A772-6B46FE29B074(a)microsoft.com... >> > Hi, >> > >> > I created a contact management DB using 2003, then upgraded it to 2007. >> > The >> > 2007 version has a contact management template that has a handy macro >> > which >> > allows you to add contacts from outlook which I copied and pasted into >> > my >> > similar form. Works great in the template I downloaded, however once I >> > put >> > the button in my DB it doesn't work - the macro has remained in tact >> > and I >> > can see no links to DB-specific objects. I tried to create a new >> > button >> > with >> > the same macro codes and still nothing. The macro is as follows: >> > >> > RunCommand: AddFromOutlook >> > >> > Pretty simple, but I get the error "The command or action >> > "AddFromOutlook" >> > isn't available right now". >> > >> > Why oh why is this button not working for me?!?!? >> >> >> . >>
|
Pages: 1 Prev: Check List in VBA Next: importing tables in proper format from word 2007 into access 2007 |