Phil
asked on
Microsoft Access 2010 Date Picker not working for bound text box to SQL Server date field
I have a Microsoft Access 2010 application and the text box bound to a SQL Server date field will not display the date picker. If I unbind the control, it displays as it should but, when bound it does not. It looks like Access does not see the field as a date field but it is set properly in SQL Server as a Date, not Date/Time.
If you view the linked table in Design view, is Access showing it correctly as a Date field?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Access sees this field as text. I'll try changing the driver.. Thanks!
ASKER
Excellent, Thank you very much!
I'm building an Access database (Access 2010) with SQL Server back end (2008). There are no linked tables. All forms are populated and bound on the Form On_Open. I had two forms (Parent and datasheet subform) that were not showing the date picker nor would they allow data entry. It turned out to be a data conversion in the SQL statement:
Note: Format does not need to be set to a date type, just the 'ShowDatePicker' needs to be set.
Convert(varchar,InstallDate,101) as InstallDate
I changed to just InstallDate and all works on the form and the datasheet subform that shares the same recordset.Note: Format does not need to be set to a date type, just the 'ShowDatePicker' needs to be set.
ConcordCA: Please post your own question, instead of tagging onto an existing one. Very few Experts will see your post, since this question is closed.
Scott:
There was a button that said the question was still open and was encouraging to add pertinent content, as I referred to in my post.
There was a button that said the question was still open and was encouraging to add pertinent content, as I referred to in my post.
Sorry - I thought you were asking a question about your project. my bad ...
it's all fine
Happy New Year! (soon) :-)
Happy New Year! (soon) :-)