Date field

[DevAccess]

Hello

I have on access form which has date field as general date format settings, but when I run the form it shows me short date only. what I want to do is If user can select date with time field as well. ?

Here is second question independent of above.

I have connected sqlite db with access as backend db, in access as we have field datatype as attachment that I dont think sqlite has similiar way, can anybody help me with how I can perform similiar functionality which sqlite like we have attachment field datatype on table on ms access.

Thanks

 

[CJ_London]

what I want to do is If user can select date with time field as well. ?

set the format property of the control to General Date.

 

[CJ_London]

I'm not familiar with sql lite, and I'm pretty sure attachment fields are unique to access. The usual way to handle this is to store the files in a common folder and store the filename in a table, then use VBA to open the file when required

 

[DevAccess]

set the format property of the control to General Date.

This does not work. For example I select 1/12/2017 in date picker it remain as it is..

 

[CJ_London]

OK, probably something to do with Access functionality. Changing the format property to

mm/dd/yyyy hh:nn:ss

works for me

 

[DevAccess]

OK, probably something to do with Access functionality. Changing the format property to

mm/dd/yyyy hh:nn:ss

works for me

I have date field which shows date in US format, I would like to have it as DD/MM/YYYY, how to achieve this ?

Thanks

 

[CJ_London]

use

dd/mm/yyyy hh:nn:ss

instead

 

[DevAccess]

use

dd/mm/yyyy hh:nn:ss

instead

This works but for this I have to lost the focus from the field to get correct dd/mm/yyyy format otherwise when I select the date from datepicker it gives mm/dd/yyyy with time format.

 

[CJ_London]

don't know why you should lose focus, all you are doing is setting a property