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
  Topic Search Topic Search  Topic Options Topic Options
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.172 seconds.