Solved

Create Google Apps Calendar Event from Access

Posted on 2010-11-23
5
2,122 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 19

Accepted Solution

by:
Bardobrave earned 500 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 84
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 84
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
This Micro Tutorial will demonstrate common damaging and frequent mistakes I see in most analytic audits. Most of them are campaign tagging mistakes, so this video will break it down into simple steps.
Shows how to create a shortcut to site-search Experts Exchange using Google in the Chrome browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch the Search Engine Menu: In chrome, via you…

751 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