Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 396
  • Last Modified:

Using VBA to Schedule appointments on a public calendar

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
NashVegas
Asked:
NashVegas
  • 4
  • 4
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
"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
 
NashVegasAuthor Commented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
Here is the basic query:

Access-EEQ24546736UpdateCalendar.mdb
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
NashVegasAuthor Commented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
OK,

Sorry, I mis-understood.
0
 
NashVegasAuthor Commented:
No worries, Jeff. Can anyone help me with this?
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now