<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

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

Published on
13,658 Points
6,958 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

Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

Join & Write a Comment

Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
A query can call a function, and a function can call Excel, even though we are in Access. This is Part 2, and steps you through the VBA that "wraps" Excel functionality so we can use its worksheet functions in Access. The declaration statement de…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month