Date field

DevAccess

Registered User.
Local time
Today, 06:08
Joined
Jun 27, 2016
Messages
321
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
 
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.
 
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
 
OK, probably something to do with Access functionality. Changing the format property to

mm/dd/yyyy hh:nn:ss

works for me
 
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
 
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.
 
don't know why you should lose focus, all you are doing is setting a property
 

Users who are viewing this thread

Back
Top Bottom