Stumped By Dates

Access 2003, WIN 7, Regional settings= English, Canada

No matter what I try formatting date field in tables, formatting or
not during insert to tables using strDate = "#" & mydate & "#" Icannot
get the table updated to dd-mm-yyy. The following is a trial SQL print
out that looks correct and Insert to the table okay but in mm/dd/yyyy
format

INSERT INTO tblDates(dtmDate1,dtmDate2)VALUES(#04/06/2012#,
#11/06/2012#) .... The dates are the fourth and eleventh of June 2012.
When inserted to the tbl they show as 06/04/2012 etc.
This seems to have started when I changed from XP to Win 7
Could someone please advise how to correct.

Thank you
.

Relevant Pages

  • Re: Setting single line spacing in word 2008
    ... But at least you've made an informed decision on the matter... ... Once again, I agree in principle, but Space Before/After Paragraphs is *not* ... a Preference, it's a formatting attribute:-) Why is it any easier to go to ... After to 0 - or do it through the Formatting Palette? ...
    (microsoft.public.mac.office.word)
  • Re: Space between decimal numbers
    ... While you're correct that it doesn't matter what language you speak, ... > I have checked the options, formatting, etc It's not helping me. ... >> If you still have the original what do you see for Format, cells, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Word - Deleting ALL formatting
    ... Velson wrote: ... sent to the printer as raw text. ... No matter what we say to the authors, they cannot resist putting figures, tables, symbols etc into their text - which messes up the printing and causes hours of proof reading and changes. ... The Word "clear formatting" command does only a partial job, and leaves many bits in place including some hidden ones which have to be picked out manually once the page proofs come back. ...
    (microsoft.public.office.misc)
  • Re: Paste text problems -- ready to cause violence
    ... black 24 pt Arial plain, no matter the size, style, colour of the ... Linda Adamshttp://www.hackman-adams.comhttp://www.david-hedison.com ... now want to make each item into a page with the formatting as in my ...
    (microsoft.public.powerpoint)
  • Date being converted to formula
    ... In a spreadsheet I use periodically, a cell at the top is to include a ... No matter what date I enter, ... delete the whole row and insert a new one, remove all formatting, ...
    (microsoft.public.excel.worksheet.functions)