Let me see if I can explain this better,

Starting from scratch…. All tables are empty..

Say you have 6 resources, (and 6 schedules). The control creates a entry for each schedule in the “Schedule Table”. This table appears to have the Key (ScheduleID) for each schedule, and is created via an auto number, so the ScheduleID can’t be some arbitrary number, like an employee number, and thus can’t be changed.

The ScheduleID is created in the order the schedules where entered. 1,2,3,4,5,6, ect

Double click on 8:00a cell for schedule 1 (which is the first schedule listed (left)) add event via the controls user interface.

Now if I change the sort order when I load the resources/schedules, so schedule ID 1 is now in the middle 4^th position, The data from the event table still loads the data to the schedule in the 1^st position.

I’m sure I’m doing something wrong, but just can’t figure it out.

Thanks For Your Help….

rgracie wrote: I’m evaluating the CalendarPro ActiveX for inclusion in a MSAccess .mde that will include group scheduling and have a couple of questions.  What are the know limitation of the control in this environment.(I have noticed a few properties and such missing when using the control inthis environment compared to VB6.)

rgracie wrote:  My needs include the use of multiple schedules, in aspecific order, with new schedules being included, with others getting removedon a fairly regular basis. (Employment variables). The schedule ID’s seemed tobe linked to the schedules position on the schedule.   How can I keep thescheduleID synchronized with the event table and still accomplish the above?

Not clear what exactly do you mean... Look at regular VB CalendarSample and try to play with Schedules configuration (in a corresponding dialog).

Hope that would help.

--
WBR,
Serge
]]> Mon, 13 Nov 2006 08:45:21 +0000 http://forum.codejock.com/forum_posts.asp?TID=5495&PID=17262&title=moving-schedules#17262 http://forum.codejock.com/forum_posts.asp?TID=5495&PID=17242&title=moving-schedules#17242 Author: rgracie
Subject: 5495
Posted: 12 November 2006 at 3:09pm

I’m evaluating the CalendarPro ActiveX for inclusion in a MSAccess .mde that will include group scheduling and have a couple of questions.

 What are the know limitation of the control in this environment.(I have noticed a few properties and such missing when using the control inthis environment compared to VB6.)

 My needs include the use of multiple schedules, in aspecific order, with new schedules being included, with others getting removedon a fairly regular basis. (Employment variables). The schedule ID’s seemed tobe linked to the schedules position on the schedule.

  How can I keep thescheduleID synchronized with the event table and still accomplish the above?

 
Thank You