remote notification on google calendar from access scheduled date

[Shem K]

Hi guys.
The above refers, and came as a request from my clients (one of the organisation's Partners for which I'm developing the database).

Background: the Firm had synchronised their Outlook accounts with Google, thus any update they make on their Google accounts is reflected on Outlook. Now, I'm looking at a way to link up a date field to Outlook Calender, and this consequently updates their Google calendar. This means they'll be able to monitor progress on their Files/ Matters remotely via Google, without necessarily having to do so by coming to use their office workstations. (In short, Access Form linking to Outlook Calendar which is linked to Google Calendar).

I think this would work for them tremendously, as, mainly the Senior Partners and Partners most of the time work from their home computers when they're away from office.

PS: I might say it looks like an elephant task. It's something I'm considering as a long-term undertaking, as I've begun the pilot phase implementation of the database, and could follow through progressively while I develop other UIs.

[Seth Schrock]

It is definitely possible to create appointments in Outlook through Access. Here is a general guide from Microsoft on how to do so: ACC: Using Automation to Add Appointments to Microsoft Outlook.

[zmbd]

Background: the Firm had synchronised their

are they still able to sync outlook<>google-calendar?

[Shem K]

Thanks for the link Seth. I'll look into the Microsoft Guide shortly.

---
Z, yes they are. And are able to manipulate events from Google calendar, with changes reflecting on their Outlook Calendar. The converse also works (I ran a test on it with my work account).

[Shem K]

Hi guys.

I generally had a busy month, working on other sections on my database. I did manage to generate a form (hoping it wins some approval). Something I noted this morning is the calendars (Google and Outlook) won't sync until Outlook is running. I created a Message Box macro, notifying a user to run outlook for the two calendars to be synchronised.

Just a thought: how can Outlook calendar be conversely used to update the form?

[Seth Schrock]

I'm not sure if Access can read from Outlook or not, but you could try Googling something like "MS Access lookup Outlook appointment". This would however warrant a new discussion thread.

[Shem K]

Thanks Seth.
I'm creating a new thread on this right away.