 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / ActiveX Controls / June 2005DateTime Picker Events
Hi All I am trying to use an unbound DTPicker control to allow the user to pick a date which will act as a parameter for a query which is the rowsource of a listbox. If i try to use the QBE grid, the DTpicker control is not listed in the form's controls. I have then tried to respond to the OnUpdated event, but I cannot get the control to trigger the event. The MSDN documentation refers to the AfterUpdate event, but this is not listed in the controls property sheet. Any suggestions how to allow the user to pick a date, and have the listbox show items whose dates are (say) >= to the selected date? Arthur Ross You cannot use controls in conjunction with queries like that. You'll have to create a form that has a calendar on it, and call the query from that form.  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Hi All > I am trying to use an unbound DTPicker control to allow the user to pick a [quoted text clipped - 10 lines] > > Arthur Ross Hi Douglas The DTPicker control and the list box are on the same form. The list box shows a set of items which contain a date. I want to allow the user to pick a date in the DTPicker and have the list box updated to show only those items with a date >= the date chosen by the user. It works fine if I use a Text box to enter the date, but I dont appear to be able to refer to the DTPicker in the QBE grid. I am happy to write code to create a recordset to act as the rowsource for the listbox, but I cant seem to trap any event for the DTPicker other than OnExit. Is there any way to tell if the DTPicker has been updated ( the onupdated event doesnt seem to fire) Thanks for your help. Arthur Ross > You cannot use controls in conjunction with queries like that. > [quoted text clipped - 15 lines] > > > > Arthur Ross Why not have the DTPicker update the text box then? SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Hi Douglas > [quoted text clipped - 39 lines] >> > >> > Arthur Ross |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.