Visual Basic :: Access 2000 Calendar Control

Microsoft Access 2000, SQL And Calendar Control
Hello!

I'm doing a little project with MS Access 2000 and I have been stucked with the following problem a few days:

I have a SQL query:

SELECT Sum(Table.Column) As Total
FROM Table WHERE Table.Date = [Forms]![MyForm]![ActiveXCtl].[Value] (I've also tried many other SQL-queries)

On the form I have a Calendar Control and its name is ActiveXCtl, I have put the following function call to the ActiveXCtl's Click-method: Form_MyForm.Total.Requery

I also have that query on the form as edit box (Name: Total).
Now when I click on a certain date on the calendar control, I would like to see query results for that date, but nothing happens.

Can anyone help me with this one?

Calendar Control With Win 2000
hi , i am having problems with this calendar control, i have developed an application that uses this control on a form .this form is called from variuos places by simply clicking a button , now after installing this application on a system running win 2000 sp1, the application runs but when the button to call the form containing this calender control is pressed , windows opens an intallation dialog box & asks the user to insert the win2000 install cd ( strange is'nt it ??) after the user cancels it the application runs showing the calender control & it never asks to install any thing even though the user calls the same calender form many times , untill the application is closed and started again , this happens only the first time the form containing the calendar control is called , any suggestions ??
thanks
yahya

Microsoft Calendar Control 8.0 WIN XP <> WIN 2000
I've developed a VB appliction with the calendar control 8.0 on a Windows XP system with Office XP.
When I run that applictation under Windows XP with Office XP, the calendar works fine.
BUT when I run the same application under Windows 2000, I can't see the values on the calendar, I only see buttons, but no dates.....

I've registered mscall.ocx on Windows 2000.

Hope somebody can tell me what's going wrong.

Thanks in advance!

Tinne.

Access 2000 Cursor Postion And Activex Calendar Ctrl
I have a form I am working on for data entry. The users enter in dates in multiple fields. I also have placed on the form for their conveinence the active x calendar control 9.0. The problem is when they decide they need to change months they use the calendar control. I would like for their cursor to stay in the field they are working in even though they are clicking on the calendar. I have seen programs do this before, just don't know exactly how it is done.

As always any and all help is greatly appreciated.

Thanks,
Remasters

VB 6.0 Calendar Control With Access Database
Ok, I'm most certain I'm not the only one who has been in this boat!

Calendar Control for VB6. Quite the nice tool. When you click on it, it passes the value of the date you clicked on to the "Value" property. Spiffy...

Now here's my dilema. I'm working on a scheduling application. My form is frm2Schedule, my ado Control is adoSched, my Calendar Control is MSched, I have text fields bound to my database for both the date, and the various time slots of this schedule application. My goal is to have the Calendar Control perform a few things:

1. When a date is clicked on in the calendar control, the function will begin a search query.
2. If this query fails (date not currently found in database), the function will call another function to create a new record, and the date for the record will match MSched.Value.
3. If this query succeeds (a record is found with that date), the function will call up this record.

Below is the start of my code. I'm familiar with VB, but this is my first time using the calendar control. Does anyone have any helpful advice to tackle this problem. I think I need to put an IF in here, but my IF failed.

Code:
Private Sub MSched_Click()
Dim nSearch As String
nSearch = MSched.Value
frm2Schedule.adoSched.Recordset.Find ("SDate =" & nSearch)
'I tried an IF statement here, but when I tested it, it failed.
'The messagebox I used to catch it never displayed.
End If
End Sub
Any help would be greatly appreciated.

Access - Using VB To Control Popup Of Calendar
I'm trying to use a calendar in Access 2003 to enter data in data fields.
I found a site that showed how to write the code so it will popup when you click on the date field and then disappear when you select the date from the calendar.
I got it working but I want to be able to access that same calendar for other date fields on the form.
So I used a variable call 'originator' to pass the originators name to the variable.
Only thing is...now it doesn't work. I get a type mismatch error and I don't know why. It's exactly the same as the example I found(obviously with my names substituted in).

Please help. (dob is the field I want the date to go into and Calendar6 is the name of the calendar I'm using.) Here's my code:

Option Compare Database
Option Explicit
Dim originator As ComboBox

Private Sub dob_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)

Set originator = dob
Calendar6.Visible = True
Calendar6.SetFocus

If Not IsNull(originator) Then
Calendar6.Value = originator.Value
Else
Calendar6.Value = Date
End If

End Sub

Private Sub Calendar6_Click()
originator.Value = Calendar6.Value
originator.SetFocus
Calendar6.Visible = False
Set originator = Nothing

End Sub

Access Date + Calendar Control
The access date when i want dd/mm/yy is weird!
it shows 24/4/01 as 4/1/24 how do i fix this?
So it's show properly?

Also with the claendar control or dt picker how do i get it to set a value into a db? when i date is clicked on?

Access & Calendar ActiveX Control
Hi,
I am creating an Access database and I want to add a Calendar control to ensure users pick a valid date. In my form I click on 'More Controls...' in the toolbox. I have a long list available and choose CoyoteCalendar2.Calendar and this adds the functionality I need.
However, I am a little worried that when I move this database to another users computer the ActiveX control may not be on their machine. Is this correct and if so how would I get the control onto their computer?
I don't even know how the Coyote Control got onto my machine - it may have been while installing another program e.g. Visual Studio.
Any help is appreciated.
Thanks,
jonny

Calendar Control In An Access Form
I have a calendar control (class MSCAL.Calendar.7 if that means anything) in an Access 2003 form. (It's actually in an Access 2000 file format.)

I have an event
Code:
Private Sub Calendar8_AfterUpdate()
Me.Text60.Value = Me.Calendar8.Value
End Sub

which does not always fire.

If I open the form in normal view the event does not fire.

If I open the form in normal view, switch to design view, open the form in normal view, the event fires.

Has anyone seen this type of behavior?

------------------------------------------------------------------------------------------------
Put your PC to good work at vbCity at world community grid and join Team vbCity.
2,669,763 3,325,308 points and ranked 1,195 1,149 as of March 8 May 23, 2008!
------------------------------------------------------------------------------------------------

Calendar Control And Simple Access Query
For some reason this won't work:

Code:

sql = "select * from Customers where Date_PS=" & Calendar1.Value

I am not sure why. The Date_PS field is a date (short date format). I have this query running on the Click event and when the value of the click is present in the access table, it won't be selected. I haven't gotten mismatch errors and have tried a bunch of formatting things to try to get a match, but at this point I am at a loss.

Thanks for your help...

Calendar Control Windows XP <-> Windows 2000
I've developed a VB appliction with the calendar control 8.0 on a Windows XP system with Office XP.
When I run that applictation under Windows XP with Office XP, the calendar works fine.
BUT when I run the same application under Windows 2000, I can't see the values on the calendar, I only see buttons, but no dates.....

I've registered mscall.ocx on Windows 2000.

Hope somebody can tell me what's going wrong.

Thanks in advance!

Tinne.

Calendar Control Windows Xp <> Windows 2000
I've developed a VB appliction with the calendar control 8.0 on a Windows XP system with Office XP.
When I run that applictation under Windows XP with Office XP, the calendar works fine.
BUT when I run the same application under Windows 2000, I can't see the values on the calendar, I only see buttons, but no dates.....

I've registered mscall.ocx on Windows 2000.

Hope somebody can tell me what's going wrong.

Thanks in advance!

Tinne.

Problems Linking Outlook Calendar To Microsoft Calendar Control In Vb.
Hi,
For a while now I've been trying to find a way to link my outlook calendar to the microsoft calendar control in visual basic. When I click on the calendar in my program, I want it to show the appointment subject in a text box and the appointment body in a Richtext box. I'd appreciate any help?
Thanks.

Custom ActiveX Control Slow In Access 2000 But Not Access 97
I have created a Calendar ActiveX control in VB 6 that I want to use in an Access 2000 database. One of the methods I have provided with my control is to change the calendar year.

The problem I am having is that when this method is called using the control in an Access 2000 database, population of the calendar is slow (about 5 seconds). If I use the same control from an Access 97 database calling the same method, population is instantaneous.

Has anyone had a similar problem to this before? Is there a compilation option in the creation of the ActiveX control that might fix this behaviour?

Thanks

Tab Control - Ms Access 2000
Dear All,

I seem to have a continuing problem that is intermittent - whenever I paste a page from one tab control to another, or a tab control itself, which contains controls, Access 2000 curls up its toes and dies.

Has anyone experienced this? It seems to happen with all sorts of different tab page set-ups, and I've tried all sorts to rectify the problem. It appears that any controls that are more complicated than a text box or label can cause it.

If anyone knows anything about it and can shed light, I would be grateful. I use Access 2000 SR-1 with WinNT SP6.

Thanks in advance,
Paul.

Data Control With Access 2000
Hello,

Can anyone tell me how do I connect Data Control to MS Access 2000?

Firstly, it gave me error of unrecognised format. So I downloaded Jet4 SP7 from the microsoft site for Windows98. But it doesn't show me any reference in

Project->References in VB6.0

I tried including a reference to msjet40.dll, but the dll could not be referenced.

Please help me out.

Mamata.

Data Control & Access 2000
I’m using Access 2000 created a database. I referenced the file to my database control in VB 6 (Service Pack 4) in the DatabaseName when I tried to select a table name from RecordSource VB prompted the error message “Unrecognized database format” and the database filename. I’m guessing that VB 6 doesn’t support Access 2000? Does anyone have answers and solutions for my problems?
Thanks in advance for any help.

Hien

Control That Outlook And Access 2000 Use...
Forgive me for repeating a question that I'm certain has been asked and answered many times before but...

What control is it that Microsoft is fond of using that sitcks to the left hand side of the screen and has different shortcuts? Most notably it's used in Outlook 2000 and MS Access 2000. Does anyone know if it's redistributable?

Thanks!

--Ben

Data Control And Access 2000?
Hi,
I'm trying to connect an Access 2000 database to VB's intristic data control (DAO) with no luck.

I've done it with Access 97, how can I do it with 2000?

Download ADO Control 4 Ms Access 2000
Any 1 know where to d/l the Ms ado control for ms access 2000 ?
pls provide the link to d/l.
Thanks

Data Control With Access 2000
Hi all,

I am using VB5 with the Data Control but am having difficulty connecting to an Access 2000 D/base.

Is the control compatible with Access 2000 ? If so how can I get it to work ??

If the control cannot be used with Access 2000 is there any other controls or ways to connect.

Any help would be much appreciated.

Thanks,

Steve

Status Bar Control In Access 2000
Does anybody know where there is some good documentation on how to use this control in Access2000/VBA?

Thanks in advance

Joe

Data Control Access 2000 +
Have recently updated my VB6 with service pack four so it can be used with access 2002. Reading the microsoft site I have changed the Microsoft DAO to version 4. This means I can now load in details from an access table into a cbo, label or text file. However although VB shows the Data selector it does not show the 'plain' grid. E.g. the DBGrid with the raw data. I am meant to be able to change the value in the Connect properties from Access to Access 2002. However this version is not shown. Is there a list of dll files I need to install and do any of these need installing via reg32.exe?

So in brief: Installed SP4, Converted Access 1997 to 2002 files, able to view in labels, textboxs and combo boxs but not DBGrid boxes which no not even show.

technically a newbie to the site but I confess I've been using it for help for while now!

Data-Control And Access 2000
Hello,

I have an application that was created with VB5, and using an Access-97 database. The database was recently converted to Access-2000. I have made the necessary modifications to use DAO 3.6 as indicated on the Microsoft Knowledge Base (http://support.microsoft.com/suppor...s/q238/4/01.asp) but the Data-Control doesn't seem to recognize the database format. I am using a DBGrid and the program crashes whenever I try to do a Data1.Refresh, or if I specify a Datasource in the control's properties... Anything I can do? Would this problem be resolved if I upgraded to VB6?

Thanks,
Stephane Gaudreau.

Selecting A Label Control In ACCESS 2000
This is a rather advanced request, and I am not sure if this is possible. I want to activate some code on label when I click on it (this part is simple enough) but I want the code to automatically grab the TAG value of the label I clicked on.

The object must be a label.

Am I missing something simple, or is this impossible?

Access 2000 Password & Data Control
I am trying to link to an Access 2000 Database that has a password on it using the Data Control function.

I am using the following code, I keep getting an error saying password not valid on the first refresh, if I take that out it says invalid database type on the second refresh.

With data1
Connect = "Access 2000;"
Refresh
Connect = ";Pwd=" & "password"
DatabaseName = App.path & "/database.mdb"
RecordSource = "MyTable"
Refresh
End With

Can anyone help?

Does Data Control Work W/ Access 2000?
I am STILL having difficulty with a program I distributed to a client weeks ago. Since I got the message "Ado could not find the specified provider" the problem, was linked back to the possibility of the latest MDAC not supporting access 97 tables and providers. So I had the choice of either finding an older MDAC, which I tried and the client said it still would not run correctly, or updating my database to 2000, which I feel is still unready for application developement. After updating my database, I found the data control is not recognizing it (which is later in the project). It is important that I use the data control as there are over 100 object properties linked to it, and I do not see where I can specify access 2000. It is probably something silly like a reference, but I cannot find it. Can anyone help! ( What I'd really like to do is stick with Access 97, but I cannot get around the provider error message.) Thanks in advance!

Whick Grid Control Should I Use? VB6/Access 2000
Hi Guys,

I find myself needing to use a grid of some sort but im unsure of which to try,

What I need is a grid with 5 colums(Headings: QTY,ITEM ID,Description,Unit Price,Total)

the colum Item must be a drop down list that takes its records from a table in the database and diaplay a list of products, when the product is chosen the rest of the grid colums except the Quantity will auto fill in with the products details, price etc.

Below all this I need to have some sort of a total price field to calculate the total price colums in the main grid.

As you have probably guessed this is to be a sort of invoice application.

Ive never used a grid for more than displaying a recordset so any help with this would be greatly appreciated.

Im using VB6 with an Access 2000 database.

Many thanks and regards
Colin

Access 2000 Forms (New Control Placement)
This is annoying.

I have an old Access 97 form that's been upgraded to Access 2000. When I try to add a new control (such as a label) to an existing form, it's making the label appear like the existing labels (in font, colors, borders, etc). But I want any new controls to appear like they do in the new Access 2000 way. (Which is how they appear when I create them on a newly created form.)

There's a "Palette Source" on my form, which has the wording "(Custom)" on it. When I deleted that, it changed the wording to "(Default)" (which is what any newly created forms have) but that didn't seem to make any difference.

Any ideas?

VB6 Data Control Won't Recognize Access 2000 DB
VB6 SP6 Data Control causes "Unrecognized database format..." error, w/MS Access 2000 DB. Please help.

Data Control Problem For Access 97/2000
Help! I just had Office 2000 installed on my computer with accompanying Access 2000 and some of my VB projects which had worked fine are now screwed up. My problems relate to accessing data from a database via a Data control. As soon as I try to refresh a Data control, I get the following error message.

“Run Time Error 3170 – Couldn’t find installable ISAM”

I can work around this problem by re-creating the Data control from scratch and filling in its properties accordingly although this is not an acceptable solution. Once I do that, however, I next get an error telling me I have an invalid password

“Run Time Error 3031 – Not a valid password”

I don’t know what this error means because the password is and has always been valid. I can open and access the database and query it via a query stream in code so I know the password is ok. The problem only occurs when I try to access the database using the Data control. Finally, if I remove the password from the database, everything works ok (assuming I created the Data control from scratch such that the 3170 run time error is avoided). Any ideas would be greatly appreciated.

KBH

Add Pix To My Custom Calendar (not A Calendar Control)
Hey,
I'm hoping maybe someone can help me. I found this piece of code on the web (don't remember where) and I've made many adjustments to it. The only problem I'm having is I can't seem to add pictures to a date. For example, when the user double clicks on a date to add a text reminder, I would like him to also add a picture to that date. I would appreciate it if any of you could lend some help. Thanx.

NOTE:
This is a simplified version of my calendar. In the calendar in the attached zip file, I have changed the way the user changes the year (it is just a simple command button) and have deleted certain parts of the code that would have just cluttered things up for someone tryin to understand the code.

Edited by - Marce22 on 12/9/2003 1:24:33 PM

Access Control In Access 2000
I made a database application is Access 2000.

Now I want to distribute to various user for use.

But I want to restrict their access - for example, end user will not be able to view
relationship, they should not see tables directly (they must see thru Forms)
etc.

I know that Access does provide a security wizard.
But my question is, if I secure a database using wizard, if I copy that database to someoher machine, do I need to configure anything extra for security.

If yes, then what other methodology should I adopt to control access to various parts of the database?

Outlook 2000 VBA Calendar Reminder Set
One of my pet peeves with Outlook Calendar is that people can send meeting invitations without the reminder turned on. (So, I miss the meeting). What I'd like to do is... when I get new mail, if it's a calendar entry, force the reminder flag to true.

So, the forum showed me everything I needed to know but I have a couple of questions.

What should I declare myMail as? I get errors when I declare it as Outlook.MailItem (because one of the entries is a calendar item), vice versa with Outlook.CalendarItem. I get an error when I set it to Outlook.Items. So, back to old faithful -- the Object.

When I get new mail, can I assume it'll be the top of the stack? Or do I have to loop through all mail (as shown below)?

Thanks in advance.

Code:
Private Sub Application_NewMail()
Dim MyMAPI As Outlook.NameSpace
Dim myFolder As Outlook.MAPIFolder
Dim objFolder As Outlook.MAPIFolder
Dim myMail As Object

On Error GoTo errorHandler
Set MyMAPI = Outlook.GetNamespace("MAPI")
Set myFolder = MyMAPI.GetDefaultFolder(olFolderInbox)

For Each myMail In myFolder.Items
If myMail.Class = olMeetingRequest Then
'Only look at Meeting Requests
myMail.ReminderSet = True
End If
Next myMail

errorHandler:
Set myMail = Nothing
Set myFolder = Nothing
Set MyMAPI = Nothing

End Sub

Change Font Size In Access 2000 For Label Control
I am creating a custom report. I am using the following code to create labels.

Set ctlLabel = CreateReportControl(frm.Name, acLabel, , _
, "NewLabel" & i, intLabelX, intLabelY, 100, 25)

I can't see to find a way to change the font size for each of the labels that I create. Is there a way to do this or is it even possible?

Thanks for your help,
Remasters

Accessing Password Protected Access 2000 Dbase Using DAO Control
Hi Folks,
I just went through some of the previous discussions to get my ADO control working with a password protected Access 2000 dbase. but how do you do the same with using an DAO control. Also I have difficulty finding the Databound Grid Control from the components list. Where can i get it? Thanks very much

Karthik.

Outlook 2000 Calendar Save As Webpage
Hi

When you are viewing your calendar in Outlook there is an function
in File -> Save as Webpage. This function works very well.

Here is my question.

I want to automate this. That means this function should start in the background for example
every 5 minutes and save the html calendar to a specified folder.

Perhaps anyone of you can help me on this or has some tipps or links to this topic.

Thank You and sorry for my English

Benny

Distribute A VB Program That Reads An Access 2000 Db On Machine Without Office 2000
Hi. I want to develop and package a VB6 program which will read an access 2000 database. I use DAO 3.6. Doesn't work on another machine without access 2000 installed. I've been told I can use MDAC_typ.exe in setup program BUT they said MDAC2.6 doesn't contain Jet files etc... I am a it confused. What should I do???
a) MDAC_typ.exe OR b) Copy certain files directly into the setup program. c) Have a beer?

Mail Merge Access 2000 With Word 2000/XP And Pass Variables
Hi, I debated posting in newbies, because I'm kind of learning VBA on the fly, and am not very good at all.

I am trying to Mail Merge an Access 2000 database with Word 2000 & Word XP.

I modified the code I got from the Microsoft Solution Base to try to introduce variables to allow me to merge more than one table and SQL query with more than one Word document.

This code works without the variables, when I just type everything directly. Unfortunately, I need the ability to merge multiple documents/tables.

Sorry if its sloppy code, I haven't really got much of an idea of what I'm doing in VBA yet.
Can anyone help me debug this, and maybe give me the syntax to use in my Macro for MergeIt(var,var,var)

I also need a way to email similar form letters. This is for a membership expired notice - some get mailed/faxed, so need to be printed, while some should be emailed. I've read that sendobject doesn't do so well. - is there a way to merge into Word (or Outlook) and automatically email these notices?

Thanks very much!!
--------------------------------------


   Function MergeIt(docaddy, sqltable, sqlstr)

    DoCmd.SetWarnings False

     DoCmd.OpenQuery "Dues Expired Calculate"
     DoCmd.OpenQuery "Dues NOT Expired Calculate"
     DoCmd.OpenQuery "Dues Are Expired"

    Dim objWord As Word.Document

    Set objWord = GetObject(docaddy, "Word.Documents")

        ' Make Word visible.

    objWord.Application.Visible = True

    ' Set the mail merge data source.

    objWord.MailMerge.OpenDataSource _

       Name:="F:workooo dbOOO Main Database.mdb", _

       LinkToSource:=True, _

       Connection:=sqltable, _

       SQLStatement:=sqlstr

    ' Execute the mail merge.

     objWord.MailMerge.Destination = wdSendToNewDocument

     objWord.MailMerge.Execute

'The following line must follow the Execute statement because the

'PrintBackground property is available only when a document window is

'active. Without this line of code, the function will end before Word

'can print the merged document.

     objWord.Application.Options.PrintBackground = False

     objWord.Application.ActiveDocument.PrintOut

End Function

------------------------------------

Thanks for any help!

Edited by - case on 7/31/2003 7:40:22 AM

How Can We Change The Control Of Day's In A Month View/Calendar Control
hi,
how can we change the control of day's in a Month view/Calendar control.

example:first week should have red colour
second week should have green colour.

Using Access 2000 To Send Emails Through Outlook 2000
I remember running across a very small piece of code a few weeks ago but for the world of me, cannot find it now and I desperately need it. This piece of code was vbscript, it basically created an smtp server and sent mail using that smtp server instead of relying on outlook to do it.

I have an access database that needs to send roughly 520 individual messages based on criteria for that specific requested area (this is not spam either, this is requested information). It worked fine until I upgraded Outlook to the latest service packs and therefore no longer works. It prompts you with the standard MS security dialog asking for permission to send the email, I can tell it yes, it will prompt me once more, I tell it yes, then it just stops. The job process never completes. I do not want to have to revert back to an "unpatched" version of outlook and the piece of code I mentioned earlier would be ideal to use.

Any help would be greatly appreciated.

Thanks in advance
Todd

Looking For Access 2000 To Sql Server 2000 Sql/query Converter
Hi guyes . I am looing for a simple to use tool that easily convert the access 2000 query or sql code to sql server 2000 code and visa versa. Thanks

Problems-Upsizing MS Access 2000 DB App To SQl Server 2000
Hi all,

I am facing some problems while upsizing my current MS Access2000 database (.mdb file) to SQL server 2000 ( trying to make a client/server application by creating a .adp file).

I did everything using Upsizing wizard available with the MS Access2000. During the Upsizing using wizard I selected the option to create a new database, connected to the SQL server out there on the network( made sure that connection was tested OK), exported all the tables( was not sure what attributes of the table to select, so i selected all the options-indexes, validation rules, defaults, table relationships using DRI and even added time stamps).

Then i selected the option to create a new Access client/server application. I got two syntax errors while upsizing(one was while upsizing queries and the other was a form).But i clicked OK and the upsizing continued with no further errors.

When i looked at the snapshot created by the wizard. All the tables were upsized properly,but none of the queries were upsized. I got errors like "The wizard was unable to analyze the SQL for this query" or "This query is not upsizeable because it depends on a Form parameter". There was no information regarding forms or reports on this snapshot.

When i opened the .adp file created by the wizard, some of the components on the Forms were not working and giving the error messages like "The record source specified on this form or report does not exist".

I am new to this field and I would appreciate if anybody suggest me something related to these problems.

Thanks in advance.

VJ

A Good VBA 2000 Reference Book For Access 2000
Hi,

I have some experience with VB6 and VB.Net, as well as Access 2000.

I can query tables and retrieve, update records, etc. What I'm looking for is a good reference book where I can look up something and find the VBA code to do it.

I'm talking about compacting the database, transferring data, attaching tables to a back-end mdb from a front-end interface, and the such. I have found that I can make a macro to do the things I've listed here and then save the macro as a module to look at the VBA code, but I need a desk reference.

I bonus would be if it detailed Access built-in functions like saving a query to transfer text in a certain format (I had to get help here for that one).

I searched Amazon.com and read some feedback, but that's tough because you don't really know the author's abilities and they don't know what mine is.

So, now that I told you what my bacic ability is and what I'm looking for, I would sure appreciate your experiences in selecting the right book for me.

Thanks,

Tom

Access 2000 Calendar Control

I am fairly new to Access, I am trying to add a calendar control to an existing database. using the calandar control i would like to be able to select dates and show all events listed for that date. is this possible?? if so please help.