Filtering Multischedules on viewing calendar |
Post Reply |
Author | |
belkaze
Groupie Joined: 10 September 2010 Status: Offline Points: 16 |
Post Options
Thanks(0)
Posted: 10 September 2010 at 9:22pm |
Hi I would like to know how to filter the view of multishedules on the Calendar. For example using the MultischedulesAccessSample14, I've managed to setup 3 user schedules. How do you filter to show one on the calendar when using a button as an example? |
|
belkaze
Groupie Joined: 10 September 2010 Status: Offline Points: 16 |
Post Options
Thanks(0)
|
Let me clarify, you have the calendar control showing the following multiple schedules
How do you filter the view with a button control event, when clicked would show just Person1 on the calendar. Both Person1 and Person2 events are stored in the same dataprovider location as in this case MSACCESS
|
|
Access2007
Groupie Joined: 21 April 2009 Location: United States Status: Offline Points: 13 |
Post Options
Thanks(0)
|
This is probably not the right way to do it, it doesn't filter the columns, but just removes the appointments from the columns that you don't want to see.
1. I changed Changed the name of the event table to events.
2. Used a combo box to filter for the person that I wanted to see. In the afterupdate event of the combo box, I had the following code to create the event query:
On Error Resume Next
Dim SchedId As Double SchedId = Me.Combo100 Dim db As Database Dim strSQL As String Dim strQueryName As String Dim qdf As QueryDef Set db = CurrentDb strQueryName = "Event" db.QueryDefs.Delete "event" Set qdf = db.CreateQueryDef("event") strSQL = "select * from events where scheduleid = " & SchedId qdf.SQL = strSQL RefreshCalendarFromDB Me.CalendarControl1.Populate Me.CalendarControl1.RedrawControl Set qdf = Nothing db.Close Set db = Nothing -----------------
Have you been able to use your own Access Form to create appointments with the AccessSampleMinimal14 sample database?
|
|
Windows 7 Pro 64
Access 2007 Calendar 15.3.1 |
|
belkaze
Groupie Joined: 10 September 2010 Status: Offline Points: 16 |
Post Options
Thanks(0)
|
Managed to sort the filtering of schedules on the Calendar control as well as the modifications of the Edit Appointment form
|
|
belkaze
Groupie Joined: 10 September 2010 Status: Offline Points: 16 |
Post Options
Thanks(0)
|
Best way was to remove and re-add the schedules to the calendar control without changing the records in the Schedule table. So basically repopulating the Calendar control with the selected schedule |
|
belkaze
Groupie Joined: 10 September 2010 Status: Offline Points: 16 |
Post Options
Thanks(0)
|
I have been able to use my own Access Form to create appointments using the AccessSampleMinimal14 sample database
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |