Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

The value you entered isn't valid for this field - Error Message

Discussion in 'Information Technology' started by R Marko, Jul 28, 2006.

  1. R Marko

    R Marko
    Expand Collapse
    Guest

    I get an error message in my main information entry form. Each time I open
    the form, place the cursor in a field and run "find record" I get an error
    message "the value entered is invalid for this field" It then finds the
    record I'm looking for.

    I saw previous posts with the same problem, but for some reason I cannot
    open the replies.

    Please help! I have 15 people who work in this database and it's driving
    them crazy.

    Rhonda
     
  2. Loading...

    Similar Threads Forum Date
    Sikh Values Blogs Oct 21, 2015
    Jainism Jainism and Sikhism: The Value of Being “Footnote” Traditions Interfaith Dialogues Jul 13, 2015
    World Why do we value gold? Breaking News Dec 9, 2013
    Canada Quebec's Charter of Values: If You Have A Personal Story, Please Share It Here! Breaking News Sep 19, 2013
    Canada Thousands March through Montreal to Protest Quebec Charter of Values (& Video) Breaking News Sep 16, 2013

  3. R Marko

    R Marko
    Expand Collapse
    Guest

    Okay, Now I'm totally baffled. I went back into the database to see if I
    could figure it out. What I found was that it only happens when running
    "find" on a select few client names. i.e. When I put the cursor in the
    field and ask for "Johnson" it goes directly to the record. Same for
    hundreds of other client names, but when I ask for "Cotton" or "Bulldog" or
    ten other client names, (that I've isolated) I get the error message. These
    clients have no more in common than any other ones. This happens EVERY TIME!
    I'm totally baffled. I made a back up of the database and
    1. Changed all fields that were required fields to "No"
    2. Increased the size of each field to 100
    3. Made sure that each field in the table was in the form

    I still get the same error message when I ask to "find" certain clients.

    Please Help!
    Rhonda


    "R Marko" wrote:

    > I get an error message in my main information entry form. Each time I open
    > the form, place the cursor in a field and run "find record" I get an error
    > message "the value entered is invalid for this field" It then finds the
    > record I'm looking for.
    >
    > I saw previous posts with the same problem, but for some reason I cannot
    > open the replies.
    >
    > Please help! I have 15 people who work in this database and it's driving
    > them crazy.
    >
    > Rhonda
     
  4. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "R Marko" <RMarko@discussions.microsoft.com> wrote in message
    news:F5FAE3D9-B9F5-42A1-A055-2AEEB8B36DAF@microsoft.com
    > Okay, Now I'm totally baffled. I went back into the database to see
    > if I could figure it out. What I found was that it only happens when
    > running "find" on a select few client names. i.e. When I put the
    > cursor in the field and ask for "Johnson" it goes directly to the
    > record. Same for hundreds of other client names, but when I ask for
    > "Cotton" or "Bulldog" or ten other client names, (that I've isolated)
    > I get the error message. These clients have no more in common than
    > any other ones. This happens EVERY TIME! I'm totally baffled. I
    > made a back up of the database and
    > 1. Changed all fields that were required fields to "No"
    > 2. Increased the size of each field to 100
    > 3. Made sure that each field in the table was in the form
    >
    > I still get the same error message when I ask to "find" certain
    > clients.


    Those aren't the actual client names ("Johnson", "Cotton", "Bulldog"),
    are they? Are you at liberty to post the actual client names you're
    searching for when it gives the error?

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  5. Danny J. Lesandrini

    Danny J. Lesandrini
    Expand Collapse
    Guest

    Dirk, are you seriously concerned for the privacy of someone with
    the last name of Johnson? I might be concerned that there are few
    people with the name Cotton or Bulldog, but if my name was Bulldog,
    I suppose I'd wear it with a badge of honor.
    --

    Danny J. Lesandrini
    dlesandrini@hotmail.com
    http://amazecreations.com/datafast


    "Dirk Goldgar" <dg@NOdataSPAMgnostics.com> wrote ...
    >
    > Those aren't the actual client names ("Johnson", "Cotton", "Bulldog"),
    > are they? Are you at liberty to post the actual client names you're
    > searching for when it gives the error?
    >
    > --
    > Dirk Goldgar, MS Access MVP
     
  6. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "Danny J. Lesandrini" <dlesandrini@hotmail.com> wrote in message
    news:u9dHxy2eGHA.3572@TK2MSFTNGP04.phx.gbl
    > Dirk, are you seriously concerned for the privacy of someone with
    > the last name of Johnson? I might be concerned that there are few
    > people with the name Cotton or Bulldog, but if my name was Bulldog,
    > I suppose I'd wear it with a badge of honor.
    >
    > "Dirk Goldgar" <dg@NOdataSPAMgnostics.com> wrote ...
    >>
    >> Those aren't the actual client names ("Johnson", "Cotton",
    >> "Bulldog"), are they? Are you at liberty to post the actual client
    >> names you're searching for when it gives the error?


    No, what I meant was, I don't think those are the real names, and I want
    to know what the real names are (in case there's something about the
    names in question), if it's okay for the OP to post them.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     

Share This Page