Outlook View Control OVC |  part two | Changing folders and interacting programmatically! Access 2007

Welcome to part two of my outlook view control tutorial/article/faq. In this tutorial I will show you how to interact with the ovc you have put on your form. if you are reading this and don’t have the ovc on a form yet go check out part one of this article https://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4616-Outlook-View-Control-OVC-part-one-Putting-the-OVC-on-an-Access-2007-form.html

Ok first I will quickly go over the non programmatic way of changing the “folder”/ what you see and then I will get into the code that you can use to interact with the OVC in Access.

To change your “folder”/what you see
1.      Right click on the ovc
2.      In the right click menu that appears select “Properties”
3.      In the properties menu click on the “folder” line so that it is selected.
4.      After you have clicked in the “folder line go up to the textbox at the top of the properties window and in it type the word “calendar”
5.      After you have typed in the word “calendar” click the “apply” button located on the left side of the text box where you just typed in “calendar.”
Bam!! You should now see one of the views of your calendar.

If you want to change the view of the calendar goto the properties menu select “view” and in the textbox on the top of the properties window type in one of the following options then click the apply button.


In the properties menu you can change any of the options. I have not explored to many of them myself but if you find one that is neat please share it with me.
      
Alllright lets get to the coding.

First the references :

Variables:

Now your ready to begin interacting with your code
      
Lets set the ovc to show our calendar.
In an event such as a button’s onclick event put this code.

‘--------start of code
                      Set MyFrame = Me.Frame0.Object
                      	Set VC = MyFrame!ViewCtl1
                      
                      With VC
                      	.Folder = “Calendar”  ‘<<set the folder to calendar
                      .View = Day/Week/Month View With AutoPreview ‘<<set the view
                      End with 
                      ‘---------end of code
                      

Select all Open in new window

The other views that can be used are the same as what you can used in the properties menu.

Now the code to view the inbox.
The inbox is the default folder but if you have switched to the calendar folder you can switch back using this method.
 Use this code in an event such as a button’s onclick event or a form’s onload event.

‘----------start of code
                      Set MyFrame = Me.Frame0.Object
                      Set VC = MyFrame!ViewCtl1
                      
                      With VC
                      	.Folder = “Inbox”  ‘<<set the folder to inbox
                      .View = Messages ‘<<set the view
                      End with
                      
                      
                      ‘-------------end of code
                      

Select all Open in new window

Some other views for the inbox are.

OK that’s all I’m going to cover in this one. I might make another article on some of the other things in outlook you can access using the ovc.
Such as send an email and set an appointment.
Have Fun...

Take a look at the sample database to this one so that you can see a working version of this.
I hope everyone who reads this learns something and finds it helpful.

Thanks for reading!


OVC.accdb