Calculated Script issues (Apple Script)

[wyldlan]

Hi

I am using an Apple Script to make a Calendar event in a particular calender and all works fine in Mac OS however I cannot seem to get it to work in the FM database.

All of the variable like current date, Event Description, Event name will come from fields in a the database.

Any help will be greatly appreciated.

thanks

Duncan

Apple script is below.

tell application "iCal"

tell calendar "Contracts"

set theDate to date "Thursday, 27 May 2010 00:00:00"

make new event with properties {description:"Event Description", summary:"Event Name", location:"Location", start date:theDate, allday event:true}

tell application "Finder"

activate

open application file "iCal.app" of folder "Applications" of startup disk

end tell

end tell

end tell

[bruceR]

Something like this?

iCal_example.fp7.zip

[wyldlan]

Many thanks for your help Bruce