Re: Update Query only works first time

Tech-Archive recommends: Fix windows errors by optimizing your registry

It would help if you posted the code and the SQL text of the query. AND
some of the error message.

I would guess that the problem is that your form has one of the records open
that you are trying to update and that your update queries are changing that
record (along with others).

Your update queries are apparently not being limited by a where clause to
only update the current record and you are probably not saving any changes
you have made on the form to the current record before you run the update
queries. After you run the queries, you may need to refresh the current
form to show the changes to the data on the form.

Again these are guesses, since you have not given sufficient information to
fully diagnose the problem.

"Jacine" <Jacine@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A2BD4578-8CA4-4BE4-BA46-507A88987549@xxxxxxxxxxxxxxxx
Hello,

I am fairly new to Access and I am stuck on two issues.

I have an inventory form that has several bin locations with their own
numerical field and another field for each bin for when they do a physical
count.

I placed a command button to run an update query for each as follows:

1. To update the current bin quantities from the actual physical count
field

2. Another to run another query to clear the actual physical count fields
to 0.

It works the first time, but then there is a very long error message with
several reasons why it does not work. When I close the form and open it
again, it works again.

I tried the DoCmd.Requery but nothing happens. Another thing - when it
does
work the first time I get a message that it is about to update 4500
records.
It only updates the current form, but I do have that many records.

Another query problem I'm am not able to figure out or know what to use is
they have a minimum and maximum number for each item and want a query set
up
that alerts which items have reached that minimum / maximum number and am
not
sure how to go about it.

I tried searching for these answers but cannot find on-line.

Many Thanks,


.

Quantcast