Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB.NET 1.0 > BOOK: Beginning VB.NET Databases
Password Reminder
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
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........
Reply With Quote
  #2 (permalink)  
Old October 22nd, 2009, 06:22 PM
Friend of Wrox
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts

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.
Reply With Quote
  #3 (permalink)  
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 ....
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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

All times are GMT -4. The time now is 02:25 PM.

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