Calender Control

  • Thread starter Thread starter K Crofts
  • Start date Start date
K

K Crofts

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
 
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.
 
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).
 
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.
 
Back
Top