Professional Web Applications Themes

Obligatory entry on form - Microsoft Access

"Lapchien" <cc8345NOSPAMeclipse.co.uk> wrote in message news:1059928544.242177ananke.eclipse.net.uk... > I'd like to make an entry obligatory in most of the fields on my form - not > just TAB or 0, but an entry - this can be anything, as I've already setup my > validation rules and texts. I've found though that a user can get around > this just by tabbing through the form! Anyone know of a work-around? Any reason you don't just set the fields as required in the table?...

  1. #1

    Default Re: Obligatory entry on form

    "Lapchien" <cc8345NOSPAMeclipse.co.uk> wrote in message
    news:1059928544.242177ananke.eclipse.net.uk...
    > I'd like to make an entry obligatory in most of the fields on my form - not
    > just TAB or 0, but an entry - this can be anything, as I've already setup my
    > validation rules and texts. I've found though that a user can get around
    > this just by tabbing through the form! Anyone know of a work-around?
    Any reason you don't just set the fields as required in the table?


    Rick Brandt Guest

  2. #2

    Default Re: Obligatory entry on form

    The ones I require are set as required - yes. But anyone can just 'tab'
    through the form...




    "Rick Brandt" <rvtjbrandtsbcglobal.net> wrote in message
    news:bgjfvi$piu2b$1ID-98015.news.uni-berlin.de...
    > "Lapchien" <cc8345NOSPAMeclipse.co.uk> wrote in message
    > news:1059928544.242177ananke.eclipse.net.uk...
    > > I'd like to make an entry obligatory in most of the fields on my form -
    not
    > > just TAB or 0, but an entry - this can be anything, as I've already
    setup my
    > > validation rules and texts. I've found though that a user can get
    around
    > > this just by tabbing through the form! Anyone know of a work-around?
    >
    > Any reason you don't just set the fields as required in the table?
    >
    >

    Lapchien Guest

  3. #3

    Default Re: Obligatory entry on form

    "Lapchien" <cc8345NOSPAMeclipse.co.uk> wrote in message
    news:1059931893.660851ananke.eclipse.net.uk...
    > The ones I require are set as required - yes. But anyone can just 'tab'
    > through the form...
    But if they are "required" by the table they will not be able to save any
    records where they didn't make an entry in those fields. They will get an error
    message.


    Rick Brandt Guest

  4. #4

    Default Re: Obligatory entry on form

    Is there any way to prevent them from leaving that particular field until an
    entry has been made, that meets the required validation?


    "Rick Brandt" <rvtjbrandtsbcglobal.net> wrote in message
    news:bgjh3a$pgjck$1ID-98015.news.uni-berlin.de...
    > "Lapchien" <cc8345NOSPAMeclipse.co.uk> wrote in message
    > news:1059931893.660851ananke.eclipse.net.uk...
    > > The ones I require are set as required - yes. But anyone can just 'tab'
    > > through the form...
    >
    > But if they are "required" by the table they will not be able to save any
    > records where they didn't make an entry in those fields. They will get an
    error
    > message.
    >
    >

    Lapchien Guest

  5. #5

    Default Re: Obligatory entry on form

    Maybe - without sounding like a total the people doing the entering
    aren't exactly brain surgeons...



    "Rick Brandt" <rvtjbrandtsbcglobal.net> wrote in message
    news:bgjlm6$or4lv$1ID-98015.news.uni-berlin.de...
    > "Lapchien" <cc8345NOSPAMeclipse.co.uk> wrote in message
    > news:1059936169.424623ananke.eclipse.net.uk...
    > > Is there any way to prevent them from leaving that particular field
    until an
    > > entry has been made, that meets the required validation?
    >
    > I suppose you could test for an entry in the OnExit event of the control
    and
    > cancel the event if they didn't make an entry. Seems unnecessary though.
    >
    > After one or two instances where they get the Required Field errors for
    leaving
    > a control blank don't you think they'll pick up on the fact that they need
    to
    > make an entry?
    >
    >

    Lapchien Guest

  6. #6

    Default Re: Obligatory entry on form

    My preference is always to use the BeforeUpdate event of the form to test
    for empty fields or to do cross field validation. It's not as annoying to
    the user that way. You can use the BeforeUpdate event of each individual
    control but it will only fire if a change has been made.

    Putting the test code into the Exit event of the control is extremely
    annoying because it will fire even when the user is trying to click a
    command button or do something unrelated to saving the record.

    --
    Sandra Daigle
    [Microsoft Access MVP]
    For the benefit of others please post all replies to this newsgroup.

    Rick Brandt wrote:
    > "Lapchien" <cc8345NOSPAMeclipse.co.uk> wrote in message
    > news:1059936169.424623ananke.eclipse.net.uk...
    >> Is there any way to prevent them from leaving that particular field
    >> until an entry has been made, that meets the required validation?
    >
    > I suppose you could test for an entry in the OnExit event of the control
    > and cancel the event if they didn't make an entry. Seems unnecessary
    > though.
    >
    > After one or two instances where they get the Required Field errors for
    > leaving a control blank don't you think they'll pick up on the fact that
    > they need to make an entry?
    Sandra Daigle Guest

  7. #7

    Default Re: Obligatory entry on form

    Yes - all the validation for the entries are setup and work okay - once the
    user actually types something into those fields. If they just tab thru - I
    don't want them to do that!

    Lap


    "Raistlin .com>" <raistlin.majere<nospamfankoo> wrote in message
    news:cXwXa.375$server.ntli.net... 
    covered 
    of 
    >
    > <SNIP>
    >
    >
    > ---
    > Outgoing mail is certified Virus Free.
    > Checked by AVG anti-virus system (http://www.grisoft.com).
    > Version: 6.0.502 / Virus Database: 300 - Release Date: 18/07/03
    >
    >[/ref]


    Lapchien Guest

  8. #8

    Default Re: Obligatory entry on form

    Sorry Lap, I wasn't being clear.
    I don't mean the validation setting in the table design I mean the default
    value setting in the table design. You can force access to prefill a field
    for you with a default value which your user can then change if they wish.
    I assume that the boxes on the form appear empty (and therefore the default
    value field on the table would be empty) when the form first loads?

    The reason I ask is that you said in your original email:
    "I'd like to make an entry obligatory in most of the fields on my form - not
    just TAB or 0,"
    Does that mean that when the form first loads the fields have a zero "0" in
    them?

    Rob.

    "Lapchien" <co.uk> wrote in message
    news:eclipse.net.uk... 
    the 

    > covered 
    > of [/ref][/ref]
    'tab' 
    > >
    > > <SNIP>
    > >
    > >
    > > ---
    > > Outgoing mail is certified Virus Free.
    > > Checked by AVG anti-virus system (http://www.grisoft.com).
    > > Version: 6.0.502 / Virus Database: 300 - Release Date: 18/07/03
    > >
    > >[/ref]
    >
    >[/ref]


    ---
    Outgoing mail is certified Virus Free.
    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.502 / Virus Database: 300 - Release Date: 18/07/03


    Raistlin Guest

Similar Threads

  1. data entry form for many-to-many
    By andy in forum Microsoft Access
    Replies: 2
    Last Post: September 1st, 08:22 AM
  2. options for form entry validation
    By Larry Rekow in forum ASP Database
    Replies: 3
    Last Post: August 9th, 12:50 PM
  3. Data entry form
    By Michael in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: December 17th, 08:49 PM
  4. Creating Data Entry Form
    By BEN MOORE in forum Microsoft Access
    Replies: 5
    Last Post: July 9th, 08:38 PM
  5. Limit user changes in entry form
    By Steve Schapel in forum Microsoft Access
    Replies: 1
    Last Post: July 8th, 09:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139