Results 1 to 3 of 3

Thread: DTPicker problem...URGENT!!!

  1. Apr 2nd, 2002, 10:54 AM #1
    w_aun83
    w_aun83 is offline

    Thread Starter
    New Member
    Join Date
    Apr 2002
    Posts
    8

    DTPicker problem...URGENT!!!

    I'm using the drpShrtTime DTPicker...the problem is when it is added to the database...it prints the date also...and after trying to format the time...it still shows the seconds...
    Reply With Quote Reply With Quote
  2. Apr 2nd, 2002, 10:57 AM #2
    kleinma
    kleinma is offline
    I'm about to be a PowerPoster! kleinma's Avatar
    Join Date
    Nov 2001
    Location
    NJ - USA (Near NYC)
    Posts
    23,373
    try something like

    Code:
    adoRS.Fields("YourTimeField") = format(DTPicker.Value,"hh:mm AMPM")
    Reply With Quote Reply With Quote
  3. Apr 2nd, 2002, 11:06 AM #3
    darre1
    darre1 is offline
    Bouncy Member darre1's Avatar
    Join Date
    May 2001
    Location
    Peterborough, UK
    Posts
    3,828
    you might wanna go into the database and edit the field in the table itself.

    i.e. in Access databases you can set the Format property of the field to "Short Time"
    Confucious say, "Man standing naked in biscuit barrel not necessarily ****ing crackers."

    Don't forget to format your code in your posts
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width