Re: Standardizing Date Fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Allan's advice is sound, but I guess it depends on exactly how you plan to
use this field. If you're never going to manipulate the date in any way, i.e.
if you're never going to sort by it, pull records using it, or calculate
future dates based on it, you could leave it a text field and use the
AfterUpdate event of the field to add the three letter designation for the
day of the week:

Private Sub YourPseudoDateField_AfterUpdate()
Me.YourPseudoDateField = YourPseudoDateField & Format(YourPseudoDateField, "
ddd")
End Sub

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

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

.

Relevant Pages

  • Re: How to beat Vanilla
    ... > There should probably be a FAQ on this subject but I was wondering if I ... But the heart of the story is good advice for anybody: ... * Always have a game plan, and think about ways to make that plan ... I tend to do better with mages because they have a few good ...
    (rec.games.roguelike.angband)
  • Re: Looking for debate
    ... There was a time in their development when it would have been good for all those guys to receive that type of advice. ... I tell him that one of my favourite players in the world holds his pick like that but that *most* other players hold it between their thumb and 1 finger. ... My guess is that he did know how to play with a pick but preferred the sound he got with his thumb and one of the reasons he preferred it was because it made him sound different than his peers. ... I'd bet that Joe Pass probably understood elementary modal theory. ...
    (rec.music.makers.guitar.jazz)
  • Re: custom pinball sound boards...
    ... any advice is welcome, ... the eight-ball boards are "plan B". ... i would like to be able to use a programmable sound board that would ...
    (rec.games.pinball)
  • =?iso-8859-1?q?Re:_Microsoft_tells_MVPs_=B3We=B9re_in_it_to_win=B2_Really=3F?=
    ... manipulate the message summaries as well. ... on a gay newsgroup because they'll manipulate the message summaries to ... that's a plan that's made a lot ... You can't play a podcast or a videocast on a Zune. ...
    (comp.sys.mac.advocacy)
  • Pool Table Construction - Critical Details
    ... Anyone helping with good advice is invited over for a game and refreshments ... some two dozen cues that came with the purchase. ... Since it's only 3/4 inch slate, and this is my first go at such a project, ... What's the best plan for attaching the ...
    (rec.sport.billiard)