Disabling New Record

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Allen Pinkley (Pinkley_at_discussions.microsoft.com)
Date: 02/11/05 

Date: Fri, 11 Feb 2005 01:19:01 -0800

I haven't coded in a while and am feeling a little rusty, but maybe someone
could help me out with this.

I have a form that is linked to a table that uses the date(short) as the
key. I want to be able to identify if the current date
(FormatDateTime(Now(), vbShortDate)) is equal to a tblDate.fldDate entry.
And if so, disable adding a new record from being created (because then it
would error and confuse some of the people who will be using it).

When a user is allowed to enter a new record (date), I have the form forcing
today's date into the text box.

Usage: daily log of work completed, organized by day. Because of this,
users should not be allowed to edit date to smug facts.

Relevant Pages

  • Re: New NUMA scheduler and hotplug CPU
    ... I talked it over with Rusty some on IRC. ... The trivial usage is to take the cpucontrol sem ). ... There's a grace period between taking the cpu offline and actually ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Re: How old is "one of the only"
    ... My feeling is that this usage is relatively recent, ... (Before writing to offer your own explanation, ... the phrase "one of the only"? ...
    (alt.usage.english)
  • How old is "one of the only"
    ... My feeling is that this usage is relatively recent, ... (Before writing to offer your own explanation, ... the phrase "one of the only"? ...
    (alt.usage.english)
  • Re: Arj nomination for Sheddi Hero
    ... >>Andrew Marshall wrote: ... >>> I had a feeling it might have been uk.singles, ... Or have you a doppelganger? ... Rusty ...
    (uk.rec.sheds)
  • Re: Op Amp circuit - I think..?
    ... I had a feeling that simple answer would come up sooner or later!! ... trouble is, I'm so rusty, I've having to go back to simple voltage dividers ... The Grimch Reaper ...
    (sci.electronics.basics)