Re: AAARGH!!! Help needed with misbehaving form link criteria

Tech-Archive recommends: Fix windows errors by optimizing your registry

The back slashes are only necessary if you are using the Format() function to
insert them. Albert already had them in the string. Any chance you would
care to send me a stripped down copy of your db that demonstrates the problem
so I could look at it? If so, I'll supply an email addy.

David Anderson wrote:
I note from both the Allen Browne link and Pieter's recent post that
backslashes are also required when reformatting a date (Albert didn't
mention those). However, even when I add backslashes, the criteria statement
on my form still does not find one of my newer records via the date. I have
now modified my app to link on a different field and all is now well - but
I'd still like to get to the bottom of this date linking problem.

David

Here are two additional links on the International Date issue:
http://www.mvps.org/access/datetime/date0005.htm
[quoted text clipped - 7 lines]
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200711/1

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200711/1

.

Relevant Pages

  • Re: AAARGH!!! Help needed with misbehaving form link criteria
    ... I note from both the Allen Browne link and Pieter's recent post that ... backslashes are also required when reformatting a date (Albert didn't ... However, even when I add backslashes, the criteria statement ... I'd still like to get to the bottom of this date linking problem. ...
    (microsoft.public.access.formscoding)
  • Re: Ping Max
    ... "Albert" wrote ... By the way I just finished a new project for my daughter which she was ... I missed a chance for a tour of a nuclear sub this month. ...
    (rec.outdoors.rv-travel)
  • Re: AAARGH!!! Help needed with misbehaving form link criteria
    ... David Anderson wrote: ... backslashes are also required when reformatting a date (Albert didn't ... However, even when I add backslashes, the criteria statement ...
    (microsoft.public.access.formscoding)
  • Re: ALBERT: Its Time To Let Him Go...................
    ... Thanks for the kind words and advice. ... I am still hoping that Albert has not found a new home just yet, ... I just want to have a chance to get him back...somehow. ... that leave food out for stray cats. ...
    (rec.pets.cats.rescue)
  • Re: Help with a tune...
    ... Albert V. ... Any chance I could have a ... Starglider Radio - listen and enjoy! ...
    (comp.sys.sinclair)