[AccessD] 3 Dates Questions

Kathryn Bassett kathryn at bassett.net
Sat Nov 5 16:32:29 CDT 2016


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




More information about the AccessD mailing list