Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Using VBA to Schedule appointments on a public calendar

Posted on 2009-07-06
8
Medium Priority
?
390 Views
Last Modified: 2013-11-28
I have developed an application that is used within our department and have received a request for some additional functionality. The users have a shared calendar on our server that they manually update to schedule workflow tasks. Ideally this could be done automatically. For example, when a shipment date is confirmed, the arrival preparation, arrival date, and follow-up actions would all be scehduled on the public calendar. Is this possible?
0
Comment
Question by:NashVegas
[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
  • 4
  • 4
8 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24787793
"Anything is possible"

The question is how difficult it is to do.

Since you did not post any details on your mysterious "application", it is difficult to say.

Basically you could have a shipment date field in a query.
When this field is populated, the other fields get populated/calculated based on that date. (ShipDate+3, ShipDate-5, ...ect)

So basically you would trigger some code to fire when a new shipment date is entered, it will then create new calendar entries for the other calculated dates.

The difficulty here would be in somehow making the code adapt for changes and/or deletions of the shipment date.

What is your "Specific" question regarding this system?

JeffCoachman
0
 

Author Comment

by:NashVegas
ID: 24787957
Hi Jeff,
Thanks for the response. My question was whether it is possible to update calendar events programmatically on a shared Outlook calendar as opposed to the user's personal Outlook calendar. I apologize if I did not make that clear. I didn't see any point in going into specifics if it turned out not to be possibile. But since you have answered that quesiton (I think) then here are specifics:

ArrivalDate: field on form that when updated triggers code that schedules 3 calendar events:
Event 1: Arrival Date - 2 days;  Subject = "Task 1"
Event 2: Arrival Date + 14 days; Subject = "Task 2"
Event 3: Arrival Date + 56 days; Subject = "Task 3"

Location of calendar (fictitious) "https://email.institution.edu/public/Med%Center/Receiving/?Cmd=contents"
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24791358
Here is the basic query:

Access-EEQ24546736UpdateCalendar.mdb
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:NashVegas
ID: 24793723
Thanks, but I already knew how to add and subtract days from a date. I was asking how to schedule appointments programmatically on a shared Outlook calendar. I don't need a query at all. I need VBA code that calls the Outlook calendar and adds the appointments. Something similar to this:

http://support.microsoft.com/kb/220595

...only it needs to schedule the appointments on the shared calendar rather than the individual user's main Outlook calendar as would occur using the code referenced in the article above.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24796567
OK,

Sorry, I mis-understood.
0
 

Author Comment

by:NashVegas
ID: 24796648
No worries, Jeff. Can anyone help me with this?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24796971
No, again, I thought you needed help with the query.

Click the Request Attention button and ask that this Q be placed in the Exchange Zone
0
 

Accepted Solution

by:
NashVegas earned 0 total points
ID: 24841011
0

Featured Post

Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
If you troubleshoot Outlook for clients, you may want to know a bit more about the OST file before doing your next job. IMAP can cause a lot of drama if removed in the accounts without backing up.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

721 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