Calendar Control 12.0

[Dick7Access]

Need tutorial or instruction on Calendar Control 12.0

 

[SOS]

Need tutorial or instruction on Calendar Control 12.0

Hi and welcome to AWF.

there isn't any out there, so what is/are your question/questions?

What do you need to know about it?

 

[Dick7Access]

Wow that was a quick answer back. Thanks. I don't know how to use CC 12.0. Not even shure it will work with Access 2007, and not sure if it will do what I want it to do. My intent is to make a calendar program something like Calendar in Vista. I am fairly knowledgeable with Access 2003, but 2007 is giving me a lot of trouble.

 

[Kiwiman]

Howzit

Welcome to AWF.

Check out Uncle Gizmo' calendar control. He even has a video demonstration. This is pretty much all I use.

http://www.access-programmers.co.uk/forums/showthread.php?t=140186

 

[SOS]

Perhaps starting with something that exists first might help:

http://www.access-programmers.co.uk/forums/showthread.php?t=140186

 

[SOS]

Howzit

Welcome to AWF.

Check out Uncle Gizmo' calendar control. He even has a video demonstration. This is pretty much all I use.

http://www.access-programmers.co.uk/forums/showthread.php?t=140186

Woah! Great minds think alike (I posted almost simultaneously)

 

[Kiwiman]

Howzit

Yep a pretty good tool that calendar...

 

[Dick7Access]

Thanks for all the quick come backs. I looked at Uncle Gizmo's, but what I am looking to make is a calendar that will show all the dates for 1 month, where I can then enter text on each of thoses days. something on the line of the calendar in Vista. I had a great calendar to do this with Calendar Creater by Broderbund but it will not work with Vista. I am not sure that calendar control 12.0 will even do what I want, which is the reason I was looking for a tutorial on Calendar control 12.0 to see if it would work like I want it to.

 

[SOS]

Calendar control 12.0 to see if it would work like I want it to.

No, it won't. The calendar control is just a calendar that looks like this:

 

[Dick7Access]

thanks SOS. and I did insert that exact image that you sent me, and it looked like what I needed, as it had the whole month at one glance. However, I did not know if I could attact text to the dates, so that is why I started this tread to see if I could find out what to do with it. What is Calendar Control 12.0 use for anyways?

 

[SOS]

What is Calendar Control 12.0 use for anyways?

Normally selecting dates. But there is no way to attach information to it.

Perhaps this would be something you would want instead. (you may have to sign up to download or get to the thread).

 

[Dick7Access]

Thanks again SOS
I have download the calendar you had on your link. It is what I am looking for. I have not been able to make it work yet, but I am still playing with it. However it was made for 97 and probable won't work on 2007. When I get a chance I will load it on my old puter that has 2003 on it and see if it works there. Thanks again.

 

[SOS]

Thanks again SOS
I have download the calendar you had on your link. It is what I am looking for. I have not been able to make it work yet, but I am still playing with it. However it was made for 97 and probable won't work on 2007. When I get a chance I will load it on my old puter that has 2003 on it and see if it works there. Thanks again.

There are things that need to be changed in 2007 from 97 so it won't be necessarily a simple thing but it can be done and if you post questions as you have them we all should be able to help.

Also have you set a trusted location for your Access 2007 yet? That is neccessary to have code work.

 

[Dick7Access]

Here I go over my head!!!
What is a trusted location and how do I set it. Things were so much simpler with 2003. I find this kind of funny as I am at the bottom of the totem pole here. In my circle I am the geek in 2003 and down. Of course my circle is very limited with lots and lots of non access programers.

 

[SOS]

What is a trusted location and how do I set it.

See here for how.

 

[Dick7Access]

SOS,
Is the trusted location a global setting or does it have to be set for all Access files. When I follow the instructions it show me this as a trust location. C:\Program Files\Microsoft Office\Office12\ACCWIZ\. When I tried to go to an indivual file it would not let me go there. Thanks again for all you help.

 

[SOS]

SOS,
Is the trusted location a global setting or does it have to be set for all Access files. When I follow the instructions it show me this as a trust location. C:\Program Files\Microsoft Office\Office12\ACCWIZ\. When I tried to go to an indivual file it would not let me go there. Thanks again for all you help.

You set it for the FOLDER that the ACCDB or MDB file is in. Not the program.

So if your ACCDB file is at C:\Users\YourUserName\My Documents Then you would have to set C:\Users\YourUserName\My Documents as a trusted location (and I usually check the subfolders checkbox too).

 

[Dick7Access]

Thank you very much.

I have all my ACCDB or MDB files in a folder called Access Files, so that should make it simpe to cover then all at one time.
Ps it is 5:05PM where I am. What time is it where you are?

 

[NigelShaw]

Hi,

i have been looking a this calendar too. it would work well when it works....

there seems to be a problem with the daily appointment. when it opens, it calls a SQL string to gather data based on appointments in the table.

i placed 5 appointments in the table ( 3 of which were dated today ). i opened up the large calendar and the entries are there. Good . i double click on the entries and it opens the daily calendar and should show the appointments on the date however it doesnt. i placed a msgbox underneath the-

Set rst = CurrentDb.OpenRecordset(strSQL)
MsgBox (strSQL)

This gives me the actual string being used
i then placed another msgbox directly above the recordcount

 MsgBox(rst.RecordCount)
If rst.RecordCount > 0 Then

The recordset comes up with 0 ( No records ) even though there are appointments in the table.

Here is the SQL string-

strSQL = "SELECT tblAppointments.*, tblHour.HourID " & _
             "FROM tblAppointments INNER JOIN tblHour " & _
             "ON tblAppointments.ApptStartTime = tblHour.Hours " & _
             "WHERE tblAppointments.AppDate = #" & dtePubMyDate & "# " & _
             "ORDER BY ApptStartTime;"

there are 2 tables.

tblAppointments holds the calendar entries
tblHour holds a list of times in 1/2 hour increments

the idea is i think is to match a record against the tblHour list the nenter the appointment in the relative place on the form.

currently it doesnt work.


Nigel

 

[Dick7Access]

Hi again SOS,
Can a Access 2007 program that I make myself be packaged so that I could give it to someone that doesn' have access on their machine, and they could run that program. I studied Visual Basic for a short while and I know that a program there can be compiled so that anybody can run it. I gave up on that idea and constrate my studies to my other intrest.