Re: Warning Message

"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: Warning Message
    ... and tried to switch the form from form view to design view the following ... >> Required property for this field is set to True. ... > Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.forms)
  • Warning Message
    ... After testing my form in form view I will try to switch to design view and ... the following error pops up: ... Prev by Date: ...
    (microsoft.public.access.forms)
  • 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: 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)