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
|
|||
|
|||
access forms
hi i want to get calendervalues in text box .that means when i click on one date on calender it will appear in the start date text box and i click on another date it will be in the end date text box.. can u please help me???????????? -- nishashanoj ------------------------------------------------------------------------ nishashanoj's Profile: http://www.msusenet.com/member.php?userid=742 View this thread: http://www.msusenet.com/t-1870407242 |
#2
|
|||
|
|||
Try this...
Using the OnEnter for [Date1], by code, set a hidden text control called [Location] on the form to "InDate1". Using the OnEnter for [Date2], by code, set a hidden text control called [Location] on the form to "InDate2". Then select a date. Use the Click event of the calendar (it doesn't show as an event in the property box, but there is a Click event in the form module) Private Sub Date1_Enter() Location = "InDate1" End Sub -------------- Private Sub Date2_Enter() Location = "InDate2" End Sub ------------ Private Sub Calendar_Click() If Location = "InDate1" Then [Date1] = Calendar.Value Location = "" ElseIf Location = "InDate2" Then [date2] = Calendar.Value Location = "" End If End Sub If you Tab into, or mouse into either field, and select a date from the calendar, the appropriate field is updated. May need a bit of fine tuning to suit, but I tested, and it seemed to work OK. hth Al Camp "nishashanoj" wrote in message ... hi i want to get calendervalues in text box .that means when i click on one date on calender it will appear in the start date text box and i click on another date it will be in the end date text box.. can u please help me???????????? -- nishashanoj ------------------------------------------------------------------------ nishashanoj's Profile: http://www.msusenet.com/member.php?userid=742 View this thread: http://www.msusenet.com/t-1870407242 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Encrypt AccesS File? | milest | General Discussion | 2 | February 9th, 2005 07:58 PM |
securing access to user forms | Paul James | Using Forms | 3 | October 9th, 2004 08:11 PM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
What is MDE | Charlie | General Discussion | 4 | August 24th, 2004 04:15 PM |
Informal testing of Access 97 Skills | david epsom dot com dot au | General Discussion | 7 | July 13th, 2004 01:36 PM |