Solved

Create Google Apps Calendar Event from Access

Posted on 2010-11-23
5
2,056 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
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

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 …
Learn about cloud computing and its benefits for small business owners.
By using UNIQUE function in Google Sheets, you can get around removing duplicates like in Microsoft Excel.
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…

911 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

23 Experts available now in Live!

Get 1:1 Help Now