Alarm Update notification to my MS Calendar

[Guest]

I want Access to notify my Calendar when priority records are due for
updates; how do I synchronise Access and Outlook to provide this alarm? I can
open a field indicating the date for the alarm, but I'm not sure how to
activate it.

 

[SusanV]

Hi Heather,

You can programmatically add an appointment to Outlook via VBA, here's some
sample code:
http://www.vba-programmer.com/Outlook_Code/Adding_Appointment_via_Automation.txt

You'll have to decide what to use as a trigger event, as I doubt all your
users would want their calendars populated when they enter the data. Perhaps
a button with a vbYesNo msgbox to warn users in case they click that
button...

 

[Phillip Windell]

I want Access to notify my Calendar when priority records are due for
updates; how do I synchronise Access and Outlook to provide this alarm? I can
open a field indicating the date for the alarm, but I'm not sure how to
activate it.

Do you have any idea how you might want to "trigger" it? Access is not a
"database server" and is not always running, and hence has no "scheduler",
so you need to have some kind of event to that "causes" it. Update only
your Calendar or anyone's/everyone's Calendar?

Just taking a blind-wild-shot-in-the-dark, you may want a boolean field in
the Record that is "No" by default and changes to "Yes" after it is added to
the Calendar. You then have a VB Script on your workstation that runs on
the Scheduled Tasks. It needs to open the DB and look for Records that have
the Boolean field set to "No",...for each one it finds it runs the piece of
script that Susan gave you to enter it into the Calendar and then update the
Record so the Boolean field is now set to "Yes".

The script would just be a *.vbs file on the workstation,...it would not be
VBA embedded in Access. It may also fail if the target Table is currently
open in a copy of Access by someone at the same time.

There are probably other ways, but that is all I can think of off the top of
my head.

(Hi Susan, I couldn't resist sneaking into the group a little bit,...NGs are
like a drug you know..)

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com
-----------------------------------------------------
Understanding the ISA 2004 Access Rule Processing
http://www.isaserver.org/articles/ISA2004_AccessRules.html

Microsoft Internet Security & Acceleration Server: Guidance
http://www.microsoft.com/isaserver/techinfo/Guidance/2004.asp
http://www.microsoft.com/isaserver/techinfo/Guidance/2000.asp

Microsoft Internet Security & Acceleration Server: Partners
http://www.microsoft.com/isaserver/partners/default.asp

Deployment Guidelines for ISA Server 2004 Enterprise Edition
http://www.microsoft.com/technet/prodtechnol/isa/2004/deploy/dgisaserver.mspx
-----------------------------------------------------

 

[SusanV]

Interesting idea Phil, using a separate VB Script. Hadn't occurred to me,
but would certainly make it unavailable to other users!

Good to see you again - how's things in the ISA group?

Susan

I want Access to notify my Calendar when priority records are due for
updates; how do I synchronise Access and Outlook to provide this alarm? I can
open a field indicating the date for the alarm, but I'm not sure how to
activate it.

Do you have any idea how you might want to "trigger" it? Access is not a
"database server" and is not always running, and hence has no "scheduler",
so you need to have some kind of event to that "causes" it. Update only
your Calendar or anyone's/everyone's Calendar?

Just taking a blind-wild-shot-in-the-dark, you may want a boolean field in
the Record that is "No" by default and changes to "Yes" after it is added
to
the Calendar. You then have a VB Script on your workstation that runs on
the Scheduled Tasks. It needs to open the DB and look for Records that
have
the Boolean field set to "No",...for each one it finds it runs the piece
of
script that Susan gave you to enter it into the Calendar and then update
the
Record so the Boolean field is now set to "Yes".

The script would just be a *.vbs file on the workstation,...it would not
be
VBA embedded in Access. It may also fail if the target Table is currently
open in a copy of Access by someone at the same time.

There are probably other ways, but that is all I can think of off the top
of
my head.

(Hi Susan, I couldn't resist sneaking into the group a little bit,...NGs
are
like a drug you know..)

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com
-----------------------------------------------------
Understanding the ISA 2004 Access Rule Processing
http://www.isaserver.org/articles/ISA2004_AccessRules.html

Microsoft Internet Security & Acceleration Server: Guidance
http://www.microsoft.com/isaserver/techinfo/Guidance/2004.asp
http://www.microsoft.com/isaserver/techinfo/Guidance/2000.asp

Microsoft Internet Security & Acceleration Server: Partners
http://www.microsoft.com/isaserver/partners/default.asp

Deployment Guidelines for ISA Server 2004 Enterprise Edition
http://www.microsoft.com/technet/prodtechnol/isa/2004/deploy/dgisaserver.mspx

 

[Phillip Windell]

Interesting idea Phil, using a separate VB Script. Hadn't occurred to me,
but would certainly make it unavailable to other users!

Yea, that is why I asked if it was only for her Calendar or for everyone's.
The method will only work for one person not only because of the local
script but also the boolean file won't "know" who made it change.

Good to see you again - how's things in the ISA group?

Some days are actually kind of slow. Also a lot of questions are either
impossible to figure out what they mean or are describing such an odd-ball
situation there is no hope of sorting it out without seeing the mess in
person. Much of the time if the person just deploys the thing properly
according to supported methods they wouldn't be having any problems to begin
with,...but then the NG would be even slower I guess.

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com
-----------------------------------------------------
Understanding the ISA 2004 Access Rule Processing
http://www.isaserver.org/articles/ISA2004_AccessRules.html

Microsoft Internet Security & Acceleration Server: Guidance
http://www.microsoft.com/isaserver/techinfo/Guidance/2004.asp
http://www.microsoft.com/isaserver/techinfo/Guidance/2000.asp

Microsoft Internet Security & Acceleration Server: Partners
http://www.microsoft.com/isaserver/partners/default.asp

Deployment Guidelines for ISA Server 2004 Enterprise Edition
http://www.microsoft.com/technet/prodtechnol/isa/2004/deploy/dgisaserver.mspx
-----------------------------------------------------

 

[SusanV]

Sounds like supporting Exchange - if they set it up *right* they wouldn't be
calling me, and now they don't even know what they did, and can't do
anything until after hours - so why did you call now if you can't DO
anything?

<sigh>

I don't miss the phones, that's for sure!

;-D

Susan

Interesting idea Phil, using a separate VB Script. Hadn't occurred to me,
but would certainly make it unavailable to other users!

Yea, that is why I asked if it was only for her Calendar or for
everyone's.
The method will only work for one person not only because of the local
script but also the boolean file won't "know" who made it change.

Good to see you again - how's things in the ISA group?

Some days are actually kind of slow. Also a lot of questions are either
impossible to figure out what they mean or are describing such an odd-ball
situation there is no hope of sorting it out without seeing the mess in
person. Much of the time if the person just deploys the thing properly
according to supported methods they wouldn't be having any problems to
begin
with,...but then the NG would be even slower I guess.

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com
-----------------------------------------------------
Understanding the ISA 2004 Access Rule Processing
http://www.isaserver.org/articles/ISA2004_AccessRules.html

Microsoft Internet Security & Acceleration Server: Guidance
http://www.microsoft.com/isaserver/techinfo/Guidance/2004.asp
http://www.microsoft.com/isaserver/techinfo/Guidance/2000.asp

Microsoft Internet Security & Acceleration Server: Partners
http://www.microsoft.com/isaserver/partners/default.asp

Deployment Guidelines for ISA Server 2004 Enterprise Edition
http://www.microsoft.com/technet/prodtechnol/isa/2004/deploy/dgisaserver.mspx