P prabha_friend Prabhakaran Karuppaih Local time Today, 09:42 Joined Mar 22, 2009 Messages 904 Sep 16, 2015 #1 I don't want to let the users to enter dates but only to select. How to do it?
Gasman Enthusiastic Amateur Local time Today, 04:12 Joined Sep 21, 2011 Messages 16,202 Sep 16, 2015 #2 Select one date?, multiple dates? If one use a combo box, ir more than one, use a multi select listbox Populate the control from where ever you keep your dates.
Select one date?, multiple dates? If one use a combo box, ir more than one, use a multi select listbox Populate the control from where ever you keep your dates.
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 12:12 Joined May 7, 2009 Messages 20,041 Sep 16, 2015 #3 on design view of your form, click on the textbox control. on the Property Sheet->Format->Short Date go to Event tab of the Property Sheet and select Keypress event. on the vbe Private Sub yourTextboxName_KeyPress(KeyAscii As Integer) KeyAscii = 0 End Sub
on design view of your form, click on the textbox control. on the Property Sheet->Format->Short Date go to Event tab of the Property Sheet and select Keypress event. on the vbe Private Sub yourTextboxName_KeyPress(KeyAscii As Integer) KeyAscii = 0 End Sub
Gasman Enthusiastic Amateur Local time Today, 04:12 Joined Sep 21, 2011 Messages 16,202 Sep 16, 2015 #4 arnelgp said: on design view of your form, click on the textbox control. on the Property Sheet->Format->Short Date go to Event tab of the Property Sheet and select Keypress event. on the vbe Private Sub yourTextboxName_KeyPress(KeyAscii As Integer) KeyAscii = 0 End Sub Click to expand... For my benefit please? Wouldn't be easier to just lock the control for that effect?
arnelgp said: on design view of your form, click on the textbox control. on the Property Sheet->Format->Short Date go to Event tab of the Property Sheet and select Keypress event. on the vbe Private Sub yourTextboxName_KeyPress(KeyAscii As Integer) KeyAscii = 0 End Sub Click to expand... For my benefit please? Wouldn't be easier to just lock the control for that effect?
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 12:12 Joined May 7, 2009 Messages 20,041 Sep 16, 2015 #5 i tried locking the control, put it wouldn't insert the date from the pop-up calendar.
Gasman Enthusiastic Amateur Local time Today, 04:12 Joined Sep 21, 2011 Messages 16,202 Sep 16, 2015 #6 arnelgp said: i tried locking the control, put it wouldn't insert the date from the pop-up calendar. Click to expand... Ah I see, I have no access to the DB, so did not realise he was using a calendar control. Thank you.
arnelgp said: i tried locking the control, put it wouldn't insert the date from the pop-up calendar. Click to expand... Ah I see, I have no access to the DB, so did not realise he was using a calendar control. Thank you.
B BlueIshDan ☠ Local time Today, 00:12 Joined May 15, 2014 Messages 1,122 Sep 16, 2015 #7 Select Pre-Existing dates within your database's records. or Select from a date-time picker?