<

Outlook View Control OVC |  part one | Putting the OVC on an Access 2007 form.

Published on
13,446 Points
6,746 Views
2 Endorsements
Last Modified:
Approved
I have seen a lot of questions about putting calendars on forms and viewing your Outlook inbox in Access. Even though many people will tell you putting the activex Outlook view control on a form is not possible i am here to show you it is. Here are the steps.

1.      Create a new blank form and go to your forms Design View. if you’re not there already right click on your form and click “design view”.
2.      insert a "Microsoft Forms 2.0 Frame" active x control onto the new form that you just created.
3.      right click on the frame you just inserted into your from.
4.      in the right click menu that pops up move up to “frame Object” and select “edit”
5.      At this point you will see the “toolbox” menu popup. Right click inside the tool box “controls” tab. (If you don’t see a menu  its because you clicked outside of the “controls” tab area.)
6.      In the right click menu click on "Additional Controls"
7.      in the additional controls menu scroll down and check the box next to  "Microsoft Office Outlook View Control. (this may already be checked)
8.      after you have clicked in the box next to “microsoft Office Outlook view control” and there is an x in the box  click the OK button.
9.      Now in the tool box a new button will appear that looks like a list box.  if you mouse over it it will have a tool tip that says "ViewCtl." click on that button.
10.      After you click on the button click go back to your frame control  (the tan box) you have on your form  and draw/drag out a box a box.

Bam!! you should at this point you should see Outlook on your form. it should default to showing your Inbox. If you do not see your inbox check out my part two to this where I will show you how to change what is being displayed in your OVC including the calendar which you will want to see.

I added some screen shots in the image below that you can look at which might help.  
ovcPart1
Ok that's it for part 1

Part 2 in the series can be found at : http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4617-Outlook-View-Control-OVC-part-two-Changing-folders-and-interacting-programmatically-Access-2007.html

Thank you for reading.
2
Comment
Author:conagraman
0 Comments

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Join & Write a Comment

Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month