Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Calendar
  New Posts New Posts RSS Feed - MS Access
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MS Access

 Post Reply Post Reply
Author
Message
moe188 View Drop Down
Senior Member
Senior Member


Joined: 27 March 2006
Status: Offline
Points: 220
Post Options Post Options   Thanks (0) Thanks(0)   Quote moe188 Quote  Post ReplyReply Direct Link To This Post Topic: MS Access
    Posted: 24 July 2006 at 4:16pm
Cry
Hi,
I checked the calendar sample (using ms access database), but I did not quite understand it (I am newEmbarrassed).
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,
 
Back to Top
sserge View Drop Down
Moderator Group
Moderator Group


Joined: 01 December 2004
Status: Offline
Points: 1297
Post Options Post Options   Thanks (0) Thanks(0)   Quote sserge Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.125 seconds.