I was searching the internet one day and I found this handy calendar. All credit goes to Jim Lunde.
JP

Only problem, every month has 31 days.

I just tried it again and everything look good at my end.

I have seen this example a few years ago, I remember now the date format must be mm/dd/yyyy

In Australia we use dd/mm/yyyy

Dave

Hi OSB
I've been using two calendars for ages which you "dug up". The first was one which selects date by double clicking on the actual date & the other is a smallish model with a red circle around the current date and uses a button to select. Both work everywhere I have put them and are very easy to get working. Anyone looking for a calendar that works well should search for them.

Here is a mini calendar (form + VB) for date inputs (very cute):
http://allenbrowne.com/ser-51.html

Hello 2 all

Can someone please help me out with the calendar that the topicstarter posted... It's no problem that every month has 31 days, but the problem is that the first day of the month is not correct. Example... june started on a thursdag but on the from it starts on a friday..:confused:

The problem might be the fact that i live in belgium and my windows regional settings are different (we use dd/mm/yyyy). Someone allready posted this problem, but does anyone knows how to fix this problem ?

I really hope y'all can help me out because i can really use this Calendar..

I would like to upload my sample but it's in dutch... if you can post the solution based on the sample of the topicstarter, that would be a great help !!

Thanks in advance !

Greetz KeLsO

Date Calendar dd/mm/yyyy

You only need to change 2 lines of code.

Edit..
Those 2 lines will get the calendar to display correctly, but not fill the days with info. A couple more lines of code need changing to allow this.

The attachment now has the spelling mistakes fixed and changes the text box color when a day has information.

Dave

Date Calendar dd/mm/yyyy

You only need to change 2 lines of code.

Dave

A very big thank you to Oldsoftboss 4 helping me out and posting the solution !!
You made my day...

Date Calendar dd/mm/yyyy

You only need to change 2 lines of code.

Dave

This calculator is just what I have been looking for. I am designing a simple way to book calls into diaries for Financial Advisors. But allowing us to get the overview of all calls booked in to date.
The problem is as follows....

We use a form (client) as a data input form. on this form we have the ability to add the date we have arranged the appointment etc. This is stored in the table (customers) we can then mail merge letters confirming the appointment.

What i would like to do is add a button so the fields (Customersurname) (Apointdate) (appointtime) (advisor) for the current record are updated into the diary automatically. So when we access the diary we can see under the relevant dates the clients surname and time of call

I Am sure this is a very simple piece of code that is needed but I just cannot get my head around it.

Please Help as my Good lady Is now not speaking to me as I have ignored her for the last 72hours :D

Hello

Me again...
After Oldsoftboy solved my date-problem... i changed some stuff and added some other stuff...

The problem that i'm having is that the text boxes of the calendar doesn't
save the data that i put in them... The data is saved in the table, it just doesn't show the data when i reopen the calendar...

Can someone help me out.. ?

Ps. i added my sample (if needed then i will translate the buttons..)

Thanks in advance !!

Hello

Me again...
After Oldsoftboy solved my date-problem..

Pardon :eek:

Glad to hear your date is OK :p

Dave

Pardon :eek:

Glad to hear your date is OK :p

Dave

Really sorry Oldsoftboss aka dave...:o and thanks again

Greetz Kelso

I'm really glad that I found this calendar as I was trying to desgin one myself. I am looking for a few differences on my input form though and cannot seem to adjust the coding or make it work right.

This form uses one large text box to input text. What I want is a drop down to select a team which will then list the employees in that team. The user will select the employee. Then there will be another drop down that provides the difference absence codes and one is selected. Finally, a text box to input the hours. The calendar day entry would read:

Name, absence code, and hours. I have worked on this all day without success so I am looking for help. I have attached a zip of the calendar along with my tables as well.

Could someone please assist me as I think I am moving into new territory as a new user.

I will have a look over the week end.

Dave

I appreciate it. It is so frustrating to know what you want to do and not be able to quite finish it. Unfortunately I want to be able to do anything and everything in Access right now, which is what makes going through the learning stages so hard.

This Db will basically do what you want, but it's not the way I would go about it. It does not cater for multiple entries for one day, and at the moment allows the selection of team, employee and code. I'm sure you can add the rest.

Dave

I appreciate you assisting me with this. I am frustrated when I cannot figure it out myself but I do realize that I still have a lot to learn. Will I ever know it all...............No!

thanks for your help on this, I really do appreciate it. I was looking at all the code entries to see how it was put together and it will be useful for future projects. I understand what you are saying about the multiple entries. What I may do is use this for a specific group that is smaller (6) so that would make it more manageable. I may need to go with the orignal calendar design for the larger groups but we will need to play with it. One question I have is this: In the calendar itself, is it possible to simply list the team, Team Member and Absence code without the labels? I tried to play around a bit with it but couldn't make that happen. Labels are not important on the output to calendar and would save some room.

In the "On_Click event of the OK button on the form: frmInputBox you should find a line of code like this:

strAbsentee = "Team - " & Me.cboTeam.Column(1) & ", Team Member - " & Me.cboTeamMember.Column(2) & " Absence Code - " & Me.cboAbsentReason.Column(1) & "."

change it to:

strAbsentee = Me.cboTeam.Column(1) & ", " & Me.cboTeamMember.Column(2) & " " & Me.cboAbsentReason.Column(1) & "."

This will only work for new entries, not existing ones. Edit those from the table.

Dave

Perfect!! I almost had it, except messed up on a few of the "". You have been a terrific help and I can't thank you enough. This one example has showed me a lot of things that will come in handy on all kinds of projects.

Jean

Cheers,

Dave

any chance it can do multiple records per day ? i have had a play and cant quite get it to do this , is there a simple way of doing it?

I'm glad that I found this calendar (Posted by MacFil). Does anyone know how to make this calendar display records (in each cell) from a query?? Please help!!!

OSB
I just had a look at your edits fo the basic form & you have done a great job, well done. I noticed that in the Current Month calendar report any wednesdays on the third line in the report have #name? showing & the corresponding day in the calendar form I couldn't delete any text I had entered in that day. I have'nt had time to do a thorough investigation yet and it has me stumped, any advice?

I corrected the spelling of Calendar, but didn't update the reports.

OSB
I'm refering to your earlier (simpler) version of the calendar with nice yellow & green background colours in the calendar form, not the version with multiple entries per day. If you look at 12th July 2006, or better still enter some text for that date, the result, on 12th July 06, when viewing the calendar form report is #name?. Deleting the data, on that particular date, is not possible either. The same thing happens with each month but is not on exactly the same date but is always once each month. Looking at it now in the calendar report I see that the offending text box is text11. Any clues where to look? By the way I really appreciate your effort on this matter.

OSB
I'm refering to your earlier (simpler) version of the calendar with nice yellow & green background colours in the calendar form, not the version with multiple entries per day. If you look at 12th July 2006, or better still enter some text for that date, the result, on 12th July 06, when viewing the calendar form report is #name?. Deleting the data, on that particular date, is not possible either. The same thing happens with each month but is not on exactly the same date but is always once each month. Looking at it now in the calendar report I see that the offending text box is text11. Any clues where to look? By the way I really appreciate your effort on this matter.

Couldn't this be because of the specific dd/mm/yy-notation that is used in the code ?

KeLsO

The control source for this textbox needs correcting:

from
=Forms!frmCalender!Text11

to
=Forms!frmCalendar!Text11

Dave

OSB
Thank you, I edited text18 (had wrong one to begin with) as you suggested & the calendar report is working ok. Im still having problems with the Calendar Form and it is something to do with the second wednesday of any month?? Even if data is written it is not possible to view it in the calendar form as every other day of a chosen month. Also I can't get the data in "the rogue wednesdays" to delete, it will disapprar then next time the form is opened the data is back. I suspect it might be something to do with the date format because changing that changes the rogue wednesday cells but not in a manner we need. One way around all of this is to create a delete query & put a extra button on the form to run it. Yeh its a "butchers" way of doing things but it will get rid of the data. What's got me is that the problem is only on one wednesday in the month, not every day, what's so special about the second wednesday????

I need to have a Calendar that can add appointments based on name, start time, end time, and description. How do I do that? Will I need four times the number of text boxes?

I think I will be able to use this calendar a great deal but it would be nice if I could enter more than one entry for each day.

I also want to have something that could last more than one day. These items would use a start date and end date and put the same thing on each day they occurred in between.

Any help would be greatly appreciated. I am new to Access and need to get this project done. Thank you.

Kevin

This is what i've been looking for.
Great!

Can anyone create a way to use this as a time booking calender for static time
ex 08.00-09.00
09.15-10.15 and so on.
and also be able to write name etc to the time entry.

And can someone help me to turn the "days" yellow and then change to another colour like in the example earlier in
the topic.
I can't get it to work

Thanks

Mikael

I am having trouble with this. I keep getting an error, error is as followed.
Public Sub PutInData()
Dim sql As String
Dim f As Form
Dim db As DOA.Database (error with DOA)
Dim rs As DOA.Recordset (error with DOA)
Dim mynum
Dim i As Integer

Set f = Forms!frmCalender

Can someone shed a little light on this subject.

Thanks,
PuJo

Hi,
I love this calendar..
how do I get it on my database?
I am extremely new at access and any help you could give me would be great!