Calendar - Custom Calendar Fields in Access?

Print Page | Close Window

Custom Calendar Fields in Access?

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Calendar
Forum Description: Topics Related to Codejock Calendar
URL: http://forum.codejock.com/forum_posts.asp?TID=11985
Printed Date: 07 October 2024 at 5:34am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Custom Calendar Fields in Access?

Posted By: Keimpe
Subject: Custom Calendar Fields in Access?
Date Posted: 27 August 2008 at 4:44am

Dear all,

I'm very impressed by Codejocks Calendar ActiveX control and wish to incorporate it in my Access (2007) database/program.

However, I have the need for extra fields to be used in Calendar appointments, but I can't figure out how to go about this.

There seems to be a fixed table, called "Event" where all the appointments are stored. If I add fields to this table, I can't add them to the appointment form -> this form also seems to pick up hard-coded fields from the Event table.

Are there any guru's here that can shed their ligths on this?

Thanks!

Keimpe Wiersma

Replies:

Posted By: AndreiM
Date Posted: 27 August 2008 at 2:10pm

Hi,

There is a CustomProperties collection where you can add aditional appointment properties.

They are stored in a single field "CustomProperies" as string in XML format and you will not have access to them using DB features (via SQL for example).

But I have one idea... if you need only read these fields values using SQL:

You may add your DB fields to Events table. On the dialog fill Event.CustomProperties.

Catch notifications EventAdded/EventChanged and copy your fields values from custom properties to your DB fields.

-------------
Regards,
Andrei Melnik