Re: DateTime Picker Help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

David,

Thanks for the quick reply. I should've noticed that one. The problem I also
have is that the value is written back to the database in US date format
when the Access database is in UK format and the DTPicker control (thanks to
your help) presents it in UK format. This is done using an SQL script but I
have raised this as another post.

Thanks for your help.

Alastair

"David Youngblood" <dwy@xxxxxxxxx> wrote in message
news:eZsK%23esZGHA.1192@xxxxxxxxxxxxxxxxxxxxxxx

"Alastair MacFarlane" <anonymous@xxxxxxxxxxxxx>...
I am trying (and failing) to set the date format of a DTPicker control to
UK
date format (dd/mm/yyyy), so I thought you would do it like this (where
DTPickFeeDate is the DTPicker Control):

DTPickFeeDate.Format = dtpCustom
DTPickFeeDate.CustomFormat = "dd/mm/yyyy"
DTPickFeeDate.Value = Date

Unexpectedly I get 23/00/2006 as the result.

The small "mm" is ussed for minutes. You need the capital "MM" for month.

DTPickFeeDate.CustomFormat = "dd/MM/yyyy"

David





.

Relevant Pages

  • Re: Masked Edit control
    ... I think I'll stick with the DTPicker. ... we now have a database that is plagued ... > in a specific format. ... >> John Connell, Database Programming. ...
    (microsoft.public.vb.controls)
  • DateTime Picker Help
    ... I am trying to set the date format of a DTPicker control to UK ... date format (dd/mm/yyyy), so I thought you would do it like this (where ...
    (microsoft.public.vb.general.discussion)
  • Re: DTPicker
    ... The text boxes all work correctly, but not DTPicker. ... ADO without using that stupid checkbox? ... one DTPicker control can handle both Date and Time. ... have the Date and Time in one field in the Jet database. ...
    (comp.lang.basic.visual.misc)
  • Re: Collecting data in MS Outlook
    ... In addition User Level Security is not supported in the new format. ... When I was converting my database, ... The link you showed only uses Microsoft Outlook 2007 and Microsoft Access ... Dim fdrInBox As Outlook.MAPIFolder ...
    (microsoft.public.access.security)
  • Re: Collecting data in MS Outlook
    ... a 3rd possibility is to not convert to the new format. ... easier is a product written to work with Outlook called Easy Survey: ... responses into an Access 2000 format database. ... Dim fdrInBox As Outlook.MAPIFolder ...
    (microsoft.public.access.security)