Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Create Google Apps Calendar Event from Access

Posted on 2010-11-23
5
Medium Priority
?
2,228 Views
Last Modified: 2014-11-12
I am moving our email from an in-house exchange server to google apps.

I currently create Calendar appointments in shared calendars using an Access 2003 Program. Now I need to achieve the same thing by creating events in Google Calendars from Access using VBA.

Any Ideas how this is done, what my code should be?

I see it's possible with .net but not sure how to do it with Access.

http://code.google.com/apis/calendar/data/2.0/developers_guide.html

Thanks,
0
Comment
Question by:stanbond
  • 2
  • 2
5 Comments
 
LVL 19

Accepted Solution

by:
Bardobrave earned 2000 total points
ID: 34195947
Google calendar is an web development API, so to include it in a project and be able to interact with it's classes into your code, you need to develop a web application (except if Google has developed a version of this app for desktop apps, but I didn't heared of that before).

What you can do is to create a simple classic ASP page with VBscript (wich is somewhat similar to VBA) that connects with your Access and tends a bridge between your Access application and Google's API.
0
 
LVL 85
ID: 34195952
You __might__ be able to use SOAP to manage this, but a much better solution would be to build a small .NET utility you could call from your Access app to add appointments and such. Google Apps are intended to be manipulated from a web-based platform, hence the very web-centric sort of interface.
0
 

Author Comment

by:stanbond
ID: 34196058
Is it as easy as posting a simple http:// address with the events details in the link?
0
 
LVL 85
ID: 34196098
From a quick review of the link you posted, no, it's not something you can pass in via a http link. You'll have to use the API to automate this.
0
 
LVL 19

Expert Comment

by:Bardobrave
ID: 34196234
For being able to use the API you need to load it into your project, like a external reference of Access, the problem is that APIs are designed for work on web environments, so you can't add a reference to it into your project and you cannot use it's classes or methods.

As LSMConsulting stated before you probably could make something through SOAP, but I think it could be a lot easier to simply use a little web app that makes the interface between your Access application and Google's Calendar API.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This Micro Tutorial demonstrates how to create custom reports and the secrets of determine the metrics and dimensions for your data that works best with your needs.
Suggested Courses

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question