Wrox Programmer Forums
|
BOOK: Beginning VB.NET Databases
This is the forum to discuss the Wrox book Beginning VB.NET Databases by Thearon Willis; ISBN: 9780764568008
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning VB.NET Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 21st, 2009, 09:24 PM
Authorized User
 
Join Date: Jan 2009
Posts: 21
Thanks: 4
Thanked 0 Times in 0 Posts
Smile I Get # 12:00:00 AM # but no Date

I gone thru the entire book using VB 2008 express and VW2005 express. I'm in chapter 16 finishing and I get an error when using my web service. My combobox on my report form bombs because the weekending date for my routine that comes from the timesheet combobox has # 12:00:00 AM # inside and it stops my program the other 3 reports that don't require dates are working fine.Can someone HELP PLEASE I am almost done. Thanks in advance........
 
Old October 22nd, 2009, 06:22 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Actually, you are getting a ZERO value for that.

It's a peculiarity of the way dates and times are stored that a "zero" date, when converted to the default display of a datetime, shows no date but *does* show the time. And, of course, 0 time is the same as "00:00:00" or "12:00:00 AM".

So your real problem is that you simply aren't getting any value, at all.

With no code to look at, that's the most I can say.
 
Old October 22nd, 2009, 09:13 PM
Authorized User
 
Join Date: Jan 2009
Posts: 21
Thanks: 4
Thanked 0 Times in 0 Posts
Smile Programmer ERROR

I double checked my code and found that I was accessing a combobox on the wrong form WeekEndingEmployeeDate instaed of WeekEndingDate. This caused me to get the default empty results from the combobox of # 12:00:00 AM #. thanks for the help and quick response ....





Similar Threads
Thread Thread Starter Forum Replies Last Post
accuracy of Now+timevalue("00:00:01") gwron Excel VBA 1 September 3rd, 2009 07:49 AM
All Time in Report appearing as 12:00:00AM blurcase Crystal Reports 0 October 11th, 2006 01:30 PM
Format rounding figure : 1235.00 => 1200.00 Jane SQL Language 1 June 27th, 2003 02:08 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.