RE: datepicker and dateformat

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

Thx for replying Damian,


but that is exactly the problem.
This date is read from the database and diplayed in a listview object
first, and when the user clicks a button this date is then exported from
the database to a csv file, which means I have to intervene twice in vba
to format it to ddmmyyyy. I can manage that, but had hoped/expected
Access to do that for me.

Any suggestions ?

thx

Ward


=?Utf-8?B?RGFtaWFuIFM=?= <DamianS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:2796ACA8-216C-4193-869A-746A542D9B7C@xxxxxxxxxxxxx:

HI Ward,

The date format you display has nothing to do with how the date is
actually stored in the database table. Simply format it the way you
want it displayed and let Access worry about how it's stored.


Hope that clarifies it for you.

Damian.

"Ward Germonpré" wrote:

Hi,

I have a datepicker on a form.
The selected date is stored in a table.
The format of that date field is 'short date notation'.

Unfortunately that doesn't work: both date AND time are stored.

I setup the datepicker object with dtpShortDate. This, combined with
the field format should yield a date only, no ?


thx for any help


Ward



.

Relevant Pages

  • RE: datepicker and dateformat
    ... thx for anyone reading my post ... This date is read from the database and diplayed in a listview object ... The date format you display has nothing to do with how the date is ... the field format should yield a date only, ...
    (microsoft.public.access.formscoding)
  • 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)
  • Re: Protel 2004 answer to Brad Velander.
    ... Sorry, you misunderstand me, I mean to say that jump from 99SE to 2004 XP ... you don't have the same format with one database will all the documents. ... Well you said that you can export file format more recent than AUTOCAD 14 ... key/mouse click you press because I don't know how to do that with Protel ...
    (sci.electronics.cad)
  • Re: Combo box not finding record... sometimes
    ... Try the Format option last. ... Private Sub cboLnNum_AfterUpdate ... when I change the data type from Double to Long Integer the database ...
    (microsoft.public.access.formscoding)