Prev: I can't add users to my database.
Next: Due Date Calculated
From: osupratt via AccessMonster.com on 6 Apr 2010 11:05
i have a sub-form that we enter invoice details into. i have a combo box that
we use to select the part number from. this has worked fine over a long
period of time. you used to be able to type in the first number or letter of
the part and it would filter down until the correct part was seen. now when
you type in the first character i get the 'field cannot be updated' error
saying that something is locked and wait for someone to get out...etc. No one
else is in this database. The combo box query comes from a linked table. Once
you clear the error by clicking ok on the error box everything works fine.

Do i need to re-build the sub-form? i am at a loss. i've checked all the
threads and have done what the threads suggest, but non of the suggestions
have worked. access 2003. any help would be appreciated. thanks.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201004/1

From: Jeanette Cunningham on 6 Apr 2010 14:42
You wrote:
"i've checked all the
threads and have done what the threads suggest, but non of the suggestions
have worked. access 2003."

I'm not sure what you have tried from your description above, but one thing
you can try is to make a new combo for the part number.
If the new combo works fine, then just delete the one giving the error.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"osupratt via AccessMonster.com" <u41837(a)uwe> wrote in message
news:a6214c10e27ad(a)uwe...
>i have a sub-form that we enter invoice details into. i have a combo box
>that
> we use to select the part number from. this has worked fine over a long
> period of time. you used to be able to type in the first number or letter
> of
> the part and it would filter down until the correct part was seen. now
> when
> you type in the first character i get the 'field cannot be updated' error
> saying that something is locked and wait for someone to get out...etc. No
> one
> else is in this database. The combo box query comes from a linked table.
> Once
> you clear the error by clicking ok on the error box everything works fine.
>
> Do i need to re-build the sub-form? i am at a loss. i've checked all the
> threads and have done what the threads suggest, but non of the suggestions
> have worked. access 2003. any help would be appreciated. thanks.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201004/1
>


From: osupratt via AccessMonster.com on 8 Apr 2010 10:36
Just to let anyone who might have the same issue know that I fixed this by
removing a timestamp field that was on my form. Once removed the error
message stopped showing up.

Jeanette Cunningham wrote:
>You wrote:
> "i've checked all the
>threads and have done what the threads suggest, but non of the suggestions
>have worked. access 2003."
>
>I'm not sure what you have tried from your description above, but one thing
>you can try is to make a new combo for the part number.
>If the new combo works fine, then just delete the one giving the error.
>
>Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
>
>>i have a sub-form that we enter invoice details into. i have a combo box
>>that
>[quoted text clipped - 13 lines]
>> threads and have done what the threads suggest, but non of the suggestions
>> have worked. access 2003. any help would be appreciated. thanks.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201004/1

 | 
Pages: 1
Prev: I can't add users to my database.
Next: Due Date Calculated