Sync Access form field with Outlook calendar event possible?

I have a field on a form named "Scheduled Date".  And then using my Outlook calendar, I wondering if I schedule a calendar event in Outlook calendar with a specific job number in the calendar Subject, and then launch the Access database, could the jobs in the tblJobs somehow bring those calendar events over to the field on the form.

Crazy I'm sure.  Anybody done this before?
SteveL13Asked:
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.

PatHartmanCommented:
Yes you can do this.  You can link to the Outlook task table.  However, I would do this from Access and then add the task to Outlook.
0
SteveL13Author Commented:
I wouldn't even know where to begin.
0
PatHartmanCommented:
Open Access
Go to the linked tables dialog
Choose Outlook
Find the table or tables you need.

If you go from Access to Outlook, you can do it by appending a row to the task table.  If you add the task in Outlook first, you will have a more complex process because you'll have to figure out what tasks are new and add them to Access.

I haven't done this in years and the functionality seems broken so I'm not sure you can do it with linked tables.  You might need to use OLE automation.

Helen Feddema has written several books that deal with interfacing Access with other Office applications.  Try contacting her at
http://www.helenfeddema.com/
to see if she can recommend a specific book that will help you.
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
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
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.