Where Are Date/time Fields In Linked Outlook Calendar Table?

I am building a database that will help schedule appointments for a business. Outlook is great for the calendar/schedule part. But, I need to connect the appointments with a customer listing and billing information to create financials. I can build all this in Access. I am able to link to the Calendar table in Outlook and am able to view all of the appointments. The problem is that I don't see any fields for the (1) date of the appointment, the (2) start time of the appointment, or the (3) end time of the appointment in the linked table? The only fields I see are listed below. Can someone give me a clue as to where I can find the date/time info for these appointments so I can use it in Access? I read in a post I found that the standard linking of this table from Outlook to Access may not show all fields. Do I need to use VBA to pull them out? Thanks!

Importance
Icon
Priority
Subject
From
Message to Me
Message CC to Me
Sender Name
CC
To
Received
Message Size
Contents
Created
Modified
Subject Prefix
Has Attachments
Normalized Subject
Object Type
Content Unread
JohnMc0620Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chris BottomleySoftware Quality Lead EngineerCommented:
Start is the property for the start date and time
0
JohnMc0620Author Commented:
There is no field listed in the table called "Start".  All the fields I am able to see are listed in the original question.  Can you explain a little more please?  Thank you!
0
Chris BottomleySoftware Quality Lead EngineerCommented:
For an appointmentitem the properties ARE start and duration.

If your table does not have these then they have not been saved OR you are not looking at an appointmentItem in outlook.

The properties referred to have more in common with an mailItem than an appointmentItem but without checking every possible property I could't swear you are referring to a mailItem.  See for example:

MailItem:

http://msdn.microsoft.com/en-us/library/microsoft.office.interop.outlook.mailitem_properties(v=office.14).aspx

AppointmentItem:

http://msdn.microsoft.com/en-us/library/microsoft.office.interop.outlook.appointmentitem_properties.aspx

Chris

Chris
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

JohnMc0620Author Commented:
Hi Chris,

I am certainly not disputing your statement about the Start and Duration fields.  And, with the links you've provided, I would completely agree with you.  All I was trying to explain was that I followed Microsoft's procedure on how to link to the calendar table so I could use it in Access I did not see these fields in the resulting linked table and was asking if there was any way to reveal them.  I agree that the fields look more like a message item than a calendar item.  As I've done more research, it seems this is documented in several forums explaining my issue.  I've seen comments stating that a method known as Office Automation needs to be used to expose these fields and be able to work with them.  Do you, or anyone else, have any experience with this?  Thank you for all your comments!
0
Chris BottomleySoftware Quality Lead EngineerCommented:
Using 'basic' vba you can connect to outlook and access any properties ... at the root of reentrant access is an awareness of the 'identity' of an outlook item.  Outlook provides an id that is generally used to give that visibility as the entryID.  Assuming you know or save the entryid then you can access a specific item any time you like and change the properties.

Let me move pc's and i'll provide an example

Chris
0
Chris BottomleySoftware Quality Lead EngineerCommented:
For example you first need to identify an appointment of interest so ...

1. Open up outlook and ensure all mails etc are closed.
2. Open up any appointment item you are3 interested in
3. Switch to access and run the following code from there:

Sub getOLKObject()
Dim olkApp As Object
Dim olkApptItem As Object
Dim strID As String

    Set olkApp = GetObject(, "outlook.application")
    strID = olkApp.activeinspector.currentitem.entryid
    Set olkApptItem = olkApp.session.getitemfromid(strID)
    MsgBox olkApptItem.Start
'    MsgBox olkApptItem.duration

End Sub

Open in new window


Note you need to lock onto precise entries and this is one way ... the easiest way (my opinion) being using entryid's but other possibilities exist so this is a demonstration of how you can view the outlook appointment olkitems from access.  Once you can view them ... you can of course change them!

Chris
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JohnMc0620Author Commented:
Chris,

Sorry it took me so long to respond to your solution.  By giving me the means to expose the EntryID of an Outlook Calendar Item, and providing me the link to the MSDN article defining all the possible attributes of an appointment item for Outlook, you've provided me with more than I could have ever dreamed of to be able to manipulate Outlook calendar items from Access!  This is a wealth of knowledge, and I am grateful to you for sharing!  Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.