acees forms

[nishashanoj]

hi,

how can i get calender control date in a text box.?means....when
click a date on the calender control,it must be appear in the tex
box..or when i enter a date in the text box ,the calender contro
changes accordingly...what can i d

 

[Jeff Conrad]

in message:

how can i get calender control date in a text box.?means....when i
click a date on the calender control,it must be appear in the text
box..or when i enter a date in the text box ,the calender control
changes accordingly...what can i do

Lots of options for you on calendars.

This is my personal favorite from MVP Stephen Lebans:
Instructions included on the site.

http://www.lebans.com/monthcalendar.htm

You can use the Calendar ActiveX Control that ships with your
Access program. You'll find it under your ActiveX Controls list.
To help you see how this works I suggest you go to Arvin Meyer's
site and download a couple of his sample databases that demonstrate
how to use the calendar.

http://www.datastrat.com/Download2.html

You may also want to check Tony Toews' site which lists many
calendar options including using forms and even an API solution.
You can find that here:

http://www.granite.ab.ca/access/calendars.htm

MVP Allen Browne has some ready made calendar forms you
can download here:

http://allenbrowne.com.au/ser-51.html

Here is a cool one in French with a slick clock as well:

http://www.logicielappui.com/tips/Acc2000_Calendar_Clock.zip

You could also read this Microsoft KB article for some help:

ACC: How to Create a Pop-Up Calendar Control on a Form
http://support.microsoft.com/?id=190194

This link gives some step-by-step instructions:

http://www.techonthenet.com/access/forms/popup_cal.htm

Here's another one of interest:

http://www.byerley.net/AccessCalDemo.zip

The Access Developer's Handbook has a form-based one
included with the book/CD:

http://www.developershandbook.com

This one might work just fine as well:

http://www.glump.net/content/accessdatepicker

There are some instructions for building one here:

http://www.tek-tips.com/faqs.cfm?fid=4601

http://www.tek-tips.com/faqs.cfm?fid=838

Hope that gives you some ideas,