Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Error about Field type/size

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

  1. langirl77

    langirl77
    Expand Collapse
    Guest

    Hi,

    I am getting an error when you go to any record in my database.
    Unfortunately I am not the only one who has access to make changes but I am
    the only one "supposed" to be doing it. I didn't make any changes so someone
    did and I don't know how to figure out what it was. The error I get is 'the
    value you entered isn't valid for this field.' It doesn't tell me what field
    so how to I figure that out. The strange thing is that when I opened Access
    help and then went to a new record to generate the error it doesn't happen.
    So with help open I don't get the error. I can still do everything I need to
    with the database but when using it I get this error. Any advice???
     
  2. Loading...


  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    It is almost certain that someone has altered the bound column of a lookup
    field. Open the form in design view and ensure that all the bound columns
    are set as you designed them to.

    The normal reason you get this error (when someone has been messing about
    with the design) is

    Lookup
    Column widths 0;2;2

    Column1 [FieldID] Auto number
    Column1 [FieldText] Text field
    Column1 [FieldText] Text field

    If the bound column has been change from 1 to (for example) 2 or 3 you will
    have text being stored in a number field – but as col 1 has a width of 0 you
    wouldn’t know this.

    After you have sorted it out you really should look at restricting access to
    anyone who doesn’t need it and know what they are doing.

    Hope this helps

    --
    Wayne
    Manchester, England.



    "langirl77" wrote:

    > Hi,
    >
    > I am getting an error when you go to any record in my database.
    > Unfortunately I am not the only one who has access to make changes but I am
    > the only one "supposed" to be doing it. I didn't make any changes so someone
    > did and I don't know how to figure out what it was. The error I get is 'the
    > value you entered isn't valid for this field.' It doesn't tell me what field
    > so how to I figure that out. The strange thing is that when I opened Access
    > help and then went to a new record to generate the error it doesn't happen.
    > So with help open I don't get the error. I can still do everything I need to
    > with the database but when using it I get this error. Any advice???
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page