[AccessD] 3 Dates Questions

Gustav Brock gustav at cactus.dk
Sat Nov 5 17:21:20 CDT 2016


Hi Kathryn

To your first question: Set the Format property to: dd mmm yyyy.

To your last question: Use the ISO sequence, yyyy-mm-dd, which nowhere can be misread.

/gustav



________________________________________
Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af Kathryn Bassett <kathryn at bassett.net>
Sendt: 5. november 2016 22:32:29
Til: 'Access Developers discussion and problem solving'
Emne: Re: [AccessD] 3 Dates Questions

On my computer, I have dd MMM yyy as the short date format, and dddd, dd MMM
yyyy set for the long date format; so the long date for the header is
working correctly to include the day of the week. What I'm trying to
accomplish is to make a date show up as, for example, 19 Oct 1778 on someone
else's computer instead of 10/19/1778.  At the very least have it as Oct 19,
1779. We need the month name, not numbers, because otherwise how does one
tell if 3/5 is Mar 5 or May 3? You have to have the month name in genealogy.
Kathryn

> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of Gustav Brock
> Sent: Saturday, 05 Nov 2016 12:03 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] 3 Dates Questions
>
> Hi Kathryn
>
> You have specified "Long date" for the one field, but no (blank) format
for
> the other.
>
> /gustav
>
> ________________________________________
> Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af
> Kathryn Bassett <kathryn at bassett.net>
> Sendt: 5. november 2016 19:01:58
> Til: 'Access Developers discussion and problem solving'
> Emne: [AccessD] 3 Dates Questions
>
> https://www.dropbox.com/s/1akv3zu8jvxf4e9/MarriageIndex.accdb?dl=0
> Question has to do with this report, and any others I might make:
> ReportBasedOnqryGroomOrder
>
> Q 1) When I open the report, the header date shows as Saturday, 05 Nov
> 2016 and Alexander Hugh's date shows as 19 Oct 1778. When my friend
> opens it, Alexander's date shows as 10/19/1778 (all dates show that way).
I'm
> sure it has to do with the way I have my computer's dates set. Is there a
way
> to force dates in reports to show up dd MMM yyyy, regardless of the way
> the system is set up?
>
> Q 2) Same report. In the table, the Notes field is set as a memo, and the
form
> has the scrollbar to see all of the field. Scroll down to Chadwick for my
> example. I put a bunch of garbage in the notes field. How do I make the
> report expand/contract to be the size needed?
>
> Q3) See ! Sample entry where I need to enter *just a year* in the date
field
> so I can put "2nd month, 9th day" in the notes when Quaker marriage dates
> are encountered. Besides Quaker dates, sometimes all I have is a year.
>
> --
> Kathryn Rhinehart Bassett (Pasadena CA)
> "Genealogy is my bag" "GH is my soap"
> kathryn at bassett.net
> http://bassett.net
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list