Now() returns Date+Time so you may try using Date() function instead or Format(Now, "mm/dd/yyyy")... Or ... you can assign default value for that field directly in your database so you wouldn't have to include this field in your Insert statement.
Microsoft MVP - Visual Basic 2006-2013 Why VB clears the clipboard on startup and how to avoid it? . Filtering Arrays . Save File To Database . Extract File From Database . Extract picture from database without using hard drive . Change Menu BackColor . How to use MS Flexgrid . Make Frame Transparent . The Easiest Way to Create an NT Service With VB6 . How to comment blocks of code in VB5 and VB6 . How to find and replace missing members of control array Visual Basic 6.0 On-Line Documentation . Connection Strings
Forum Rules
Reply With Quote