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

Date field cannot be updated

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

  1. please help

    please help
    Expand Collapse
    Guest

    I am trying to enter information into a form and i get a warning sign that
    reads "field cannot be updated" after clicking ok thru the sign 5 times it
    lets me update the field. When I go to the query and the table the field is
    based on I do not get the warning sign. It lets me update the date field
    perfectly fine. I have already checked there are no data locks or macros
    that would affect this field. Please help!!!
     
  2. Loading...


  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    Is there more than one user at a time? Is the form based on more than one
    table? If not, it just might be a corruption issue.

    Tony Toews has an excellent web page on database corruption.
    http://www.granite.ab.ca/access/corruptmdbs.htm

    Allen Brown also has excellent info on corruption.
    http://allenbrowne.com/ser-47.html

    I have a white paper in a Word document named Fix Corrupt Access Database
    towards the bottom this page:
    http://www.rogersaccesslibrary.com/OtherLibraries.asp
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "please help" wrote:

    > I am trying to enter information into a form and i get a warning sign that
    > reads "field cannot be updated" after clicking ok thru the sign 5 times it
    > lets me update the field. When I go to the query and the table the field is
    > based on I do not get the warning sign. It lets me update the date field
    > perfectly fine. I have already checked there are no data locks or macros
    > that would affect this field. Please help!!!
     
  4. please help

    please help
    Expand Collapse
    Guest

    There is more than 1 user but not at the same time. The form is based on 1
    table, upon which I createda query and then the form from the query.

    "Jerry Whittle" wrote:

    > Is there more than one user at a time? Is the form based on more than one
    > table? If not, it just might be a corruption issue.
    >
    > Tony Toews has an excellent web page on database corruption.
    > http://www.granite.ab.ca/access/corruptmdbs.htm
    >
    > Allen Brown also has excellent info on corruption.
    > http://allenbrowne.com/ser-47.html
    >
    > I have a white paper in a Word document named Fix Corrupt Access Database
    > towards the bottom this page:
    > http://www.rogersaccesslibrary.com/OtherLibraries.asp
    > --
    > Jerry Whittle
    > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
    >
    >
    > "please help" wrote:
    >
    > > I am trying to enter information into a form and i get a warning sign that
    > > reads "field cannot be updated" after clicking ok thru the sign 5 times it
    > > lets me update the field. When I go to the query and the table the field is
    > > based on I do not get the warning sign. It lets me update the date field
    > > perfectly fine. I have already checked there are no data locks or macros
    > > that would affect this field. Please help!!!
     
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