Can the text portion of the combobox be made "editable"? The way it stands now, it appears you can only search on a specific list item (Equals) and leaves the rest of the advanced options irrelevant if the list item values are physicians names. Is there any way of joining the "searchable" BO to a textbox instead of a combobox where entered text could be used to do partial name searches instead of exact matches?
At present, no. You are basically wanting to search a different table than the browsedialog represents. In our medical software, we simply populate this combo with the doctors and they can choose which doctor (which uses the normalized foreign key field). To be able to search on the last name of the doctor, that field would have to exist in the table in which you are searching.
One of my search fields is a datetime field. Is there anyway to force the format of the date display in the text portion of the datetimepicker control (e.g. "02/06/2008" instead of " 2/ 6/2008")?
This is controlled by the machine settings. You can change this on the computer's Regional and Language settings....this is not hardcoded as different countries use different date/time formats. Open up the control panel in Windows and go to Regional and Language Options.
The date search field I have setup is a datetime field in the database. When the data is added/updated, only the date is supplied so the db value is always "mm/dd/yy 12:00:00AM". When a search is done with a date field by using the "generated" datetimepicker control, is the time also being used? I can't get any "hits" using the "Equals" option for a specific date. I have to use "Less Than" or "Less Than Or Equal To" but then I get unwanted rows return. Is there anyway to search just for a specific date reguardless of time?
Scroll further over in the options when setting up a date/time field:
