Solved

Create Google Apps Calendar Event from Access

Posted on 2010-11-23
5
2,033 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 500 total points
Comment Utility
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 84
Comment Utility
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
Comment Utility
Is it as easy as posting a simple http:// address with the events details in the link?
0
 
LVL 84
Comment Utility
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
Comment Utility
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

The Challenge I was developing a new website for a client the other week in WordPress and they asked me if it was possible to track the clicks of the sponsor images they include on their home page. My first port of call was to use the Yoast Google …
With voice direction tools, various map viewing styles, the ability to get directions for different means of transportation and great service, Google Maps is simply one of the best navigations app in the market.    However, over the past year, an …
This Micro Tutorial demonstrates how to quickly find related content for YourTango's posts using MozBar Chrome extension.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

762 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now