Results 1 to 3 of 3

Thread: Month of DtPicker

  1. Feb 22nd, 2012, 03:13 AM #1
    yasrab
    yasrab is offline

    Thread Starter
    Lively Member
    Join Date
    Nov 2011
    Posts
    74

    Month of DtPicker

    the Dtpicker format to show on the form is custom that is MMMM/yyyy.

    now whenever change the value of dtpicker by its "change" function then if it has january and i increase its value to february then it shows february to view but the value it gives will be March in the below syntax:

    Mnth = format(dtpicker1.value , "MMMM")

    this bug only arise if the day value of january will be 31.

    any sugestion.

    also wat is the query for taking month and year from a date field of access.
    Reply With Quote Reply With Quote
  2. Feb 22nd, 2012, 08:05 AM #2
    RhinoBull
    RhinoBull is offline
    PowerPoster RhinoBull's Avatar
    Join Date
    Mar 2004
    Location
    New Amsterdam
    Posts
    24,132

    Re: Month of DtPicker

    Trap the error and proceed accordingly; validate Value before formatting...
    It basically gets you down to one point: you must handle exceptions.
    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
    Reply With Quote Reply With Quote
  3. Feb 22nd, 2012, 10:35 AM #3
    DataMiser
    DataMiser is offline
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,206

    Re: Month of DtPicker

    Maybe it has nothing to do with January 31st since this occurs every year.
    Perhaps it is struggling with the fact that Febuary has 29 days this year.
    Maybe jumping from end of January to end of Febuary but then mistaken Feb 29 for Mar 1
    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