[AccessD] 3 Dates Questions

[Darryl Collins]

Are you using VBA somewhere in the process to produce the date?  

Be aware that any dates processed via VBA are converted to that (IMHO most annoying) US format (MM/DD/YYYY) *regardless* of your OS and regional settings unless you handle them specifically using DATESERIAL or similar.

Regards
Darryl.


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kathryn Bassett
Sent: Sunday, 6 November 2016 8:32 AM
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Subject: 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