If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calender Control
How do i create a diary-style form that functions? i can
create the form with a calender control on it that is always visable but i need to be able to click on a date and the form should change to reflect that day ie. ideally i would need the form to work exactly the same as the outlook calender. Any ideas? i have posted this numerous times but no-one has given me any help or advice, i am willing to completely re-think the project if this is not viable. Thanks |
#2
|
|||
|
|||
Calender Control
The question is too general, K. Attempting to recreate the Outlook calendar
in Access is a very big, very ambitious project. I'm sure many people would be delighted to offer help and advice with such a challenging project, but you need to narrow it down a bit, to ask specific questions about specific aspects of the project. As for whether the project is viable or not, I'll ask the obvious question - if you want it to work exactly the same as the Outlook calendar, why are you not using Outlook? -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "K Crofts" wrote in message ... How do i create a diary-style form that functions? i can create the form with a calender control on it that is always visable but i need to be able to click on a date and the form should change to reflect that day ie. ideally i would need the form to work exactly the same as the outlook calender. Any ideas? i have posted this numerous times but no-one has given me any help or advice, i am willing to completely re-think the project if this is not viable. Thanks |
#3
|
|||
|
|||
Calender Control
Im not using the Outlook Calender as i only require the
same functioning but need a completely diffeerent desgn, i also need to be able to create reports based on the information that has been entered. I currently have the form set up with the calender on it, on calender click i am currently using the docmd.GoToRecord ,,acNewRec command, this works quite well but i need the records to associate to the dates on the calender, i.e. when i add data to the record for 15/08/03 i need to be able to retrive this data later on by selecting the same date on the calender, not by flicking through the individual records.Hope this makes sense, any help (or alternatives) would be greatly appreciated (thanks Brendan). -----Original Message----- The question is too general, K. Attempting to recreate the Outlook calendar in Access is a very big, very ambitious project. I'm sure many people would be delighted to offer help and advice with such a challenging project, but you need to narrow it down a bit, to ask specific questions about specific aspects of the project. As for whether the project is viable or not, I'll ask the obvious question - if you want it to work exactly the same as the Outlook calendar, why are you not using Outlook? -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E- mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e- mail, you'll find a useable e-mail address at the URL above. "K Crofts" wrote in message ... How do i create a diary-style form that functions? i can create the form with a calender control on it that is always visable but i need to be able to click on a date and the form should change to reflect that day ie. ideally i would need the form to work exactly the same as the outlook calender. Any ideas? i have posted this numerous times but no-one has given me any help or advice, i am willing to completely re-think the project if this is not viable. Thanks . |
#4
|
|||
|
|||
Calender Control
K, I'm an idiot! :-(
I read the body of your post, but failed to pay attention to the subject line. I see now that, taking the subject line into account, your question is not as general as I thought it was. I'm not the best person to advise you on the use of the calendar control, as I've avoided it because of the many version conflict problems we've seen reported here. But my understanding, from previous posts in the newsgroups, is that the Value property of the control returns the selected date. So I believe you would retrieve the matching records with a query that looked something like ... "SELECT * FROM YourTable WHERE YourDateField = Forms!YourForm!YourCalendarControl.Value; If anyone with more experience of using the calendar control would like to jump in here, do please feel free! :-) -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "K Crofts" wrote in message ... Im not using the Outlook Calender as i only require the same functioning but need a completely diffeerent desgn, i also need to be able to create reports based on the information that has been entered. I currently have the form set up with the calender on it, on calender click i am currently using the docmd.GoToRecord ,,acNewRec command, this works quite well but i need the records to associate to the dates on the calender, i.e. when i add data to the record for 15/08/03 i need to be able to retrive this data later on by selecting the same date on the calender, not by flicking through the individual records.Hope this makes sense, any help (or alternatives) would be greatly appreciated (thanks Brendan). -----Original Message----- The question is too general, K. Attempting to recreate the Outlook calendar in Access is a very big, very ambitious project. I'm sure many people would be delighted to offer help and advice with such a challenging project, but you need to narrow it down a bit, to ask specific questions about specific aspects of the project. As for whether the project is viable or not, I'll ask the obvious question - if you want it to work exactly the same as the Outlook calendar, why are you not using Outlook? -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E- mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e- mail, you'll find a useable e-mail address at the URL above. "K Crofts" wrote in message ... How do i create a diary-style form that functions? i can create the form with a calender control on it that is always visable but i need to be able to click on a date and the form should change to reflect that day ie. ideally i would need the form to work exactly the same as the outlook calender. Any ideas? i have posted this numerous times but no-one has given me any help or advice, i am willing to completely re-think the project if this is not viable. Thanks . |
Thread Tools | |
Display Modes | |
|
|