- Use date picker control in vb.net and set the Format property of the control to the required date format.
- Now in MS Access 2007 open the tables design view and set the format property of the corresponding fields’ data type to match the data type of date picker control of vb.net application.
- Now perform SQL date operations like a normal query, with out any need for code to change the date format for Ms Access.
No comments:
Post a Comment