clockwork3orange
Member
- Joined
- Oct 20, 2006
- Messages
- 21
- Programming Experience
- Beginner
I am using VB.NET 2008 Express edition with a connection to MS Access 2007 saved as an .mdb not .accdb. If I set the database to create the primary key and all the fields are text there is no issue. However if I set several fields as a simple date mm/dd/yyyy i run into problems. When I output the results of a date in a text field it prints like this 7/14/2009 12:00:00 AM. If I try to add a new record I cannot unless all of the fields set as dates in the database are typed in this format 7/14/2009 12:00:00 AM. I need a few fields as dates for sorting reasons. I also have it set so when I add records to the database they are in single quotes. I removed the quotes but it still complains.