Re: Warning Message



Your comment helped. I do have one more question. After I fixed this problem
and tried to switch the form from form view to design view the following
error occurred, "Error Error Evaluation CHECK constraint. In the validation
rule. What does this mean?

"Dirk Goldgar" wrote:

> "j1eggert" <j1eggert@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:3AA66B18-70B2-438E-BA10-2D9C48C853AB@xxxxxxxxxxxxx
> > After testing my form in form view I will try to switch to design
> > view and the following error pops up: "The field
> > 'tblProgtams.txtShTitle' cannot contain a Null value because the
> > Required property for this field is set to True. Enter a value in
> > this field." If someone could hlep me better understand this error
> > message it would be greatly appreciated.
> >
> > Sincerely,
> > James E.
>
> Offhand, I'd say that when in form view, you "dirtied" the current
> record -- that is, you changed the value of one or more of the fields..
> When you switched back to design view, Access naturally attempted to
> save this record, but couldn't because the field txtShTitle was blank,
> but the table definition says this is a required field.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
>
.



Relevant Pages

  • Re: Flourescent lamp -Wasting Power?
    ... > to the real power being dissipated by that electronic ballast. ... > kludge up a setup to measure the real power - without frying myself. ... > stupid design that I just multiplied current times voltage in my head ... > controlled by a single pole four position rotary switch which sequences ...
    (sci.electronics.design)
  • Re: Warning Message
    ... > After testing my form in form view I will try to switch to design ... > view and the following error pops up: ... When you switched back to design view, ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.forms)
  • Re: About interactivity.
    ... Well that was done with Strowger and other mechanical exchanges. ... It is a matter of design not language. ... How in the Earth did you make a change in the equivalent to changing the engineering of a telephone switch without interrupting the connections going on? ... how did you with Strowger or Crossswitches did you swapped exchanges without dropping the connections they were serving? ...
    (comp.lang.forth)
  • RE: How to switch views using command button
    ... Private Sub SwitchBtn_Click ... Set accObj = CurrentProject.AllForms ... >> I wonder if there is such code that allows me to switch between Design View ...
    (microsoft.public.access.forms)
  • Re: HTML AutoFormatting (with an actual question)
    ... Is there any way in VS.NET 2003 to complete disable the Design ... I want to make sure that I never switch to it, ... my problem now is adding server controls. ... > declaration to the .cs code-behind page, ...
    (microsoft.public.vsnet.ide)