MS Access : Hi,1. As you can see in this sample,...

Sun, 30 Jul 2006 18:20:45 +0000

Author: sserge
Subject: 4649
Posted: 30 July 2006 at 6:20pm

Hi,

1. As you can see in this sample, when loading a form, you connect CalendarControl with the MDB file itself:


Me.CalendarControl1.SetDataProvider Application.ADOConnectString
Me.CalendarControl1.DataProvider.Open

Then Calendar uses internal functionality to access tables with data.

2. Using Calendar's functionality:


Dim Events As CalendarEvents
 Set Events = CalendarControl.DataProvider.RetrieveDayEvents(YourDate)

3. You can switch views programmatically like:


Me.CalendarControl1.ViewType = xtpCalendarWeekView

In the sample views are shown as a set of buttons, clicking runs a code above.

4. Data will be saved automatically to the appropriate tabe (Table Event for appointments).

Hope this helps.

--
WBR,
Serge

MS Access : Hi, I checked the calendar...

Mon, 24 Jul 2006 16:16:35 +0000

Author: moe188
Subject: 4649
Posted: 24 July 2006 at 4:16pm

Hi,

I checked the calendar sample (using ms access database), but I did not quite understand it (I am new).

So, some help here:

1- how to connect the calendar control to database (db1.mdb)?

2- how to retrieve the data from a recordset (rstAppointment) for today's date or any date selected by the user.?

3- how can I display the result for the the different type of view (week view, workweek view, month view), do I have to use code to do so, or it will be built in?

4- how can I save a new data entered by the user to the rstAppointment?

Thank you,

Codejock Developer Community : MS Access

MS Access : Hi,1. As you can see in this sample,...

MS Access : Hi, I checked the calendar...