may I suggest a good book on how access works? that might help you along. or just SQL. that might work too. it seems that you probably have a WHERE clause in your statement if the query if updating only certain records.
An UPDATE query ALWAYS updates as many records in a table as are selected or implied or condoned by the combination of the named table (UPDATE tblname SET ...) and the WHERE clauses that filter the table's records according to field contents. If you only updated one record then you must have specified WHERE-clause filters that left you only one record. OR there was only one record in the table, though from your comments, that doesn't seem as likely.
To know exactly what you did / how you did that, could you show us your query? Open it in SQL view, highlight it, copy it, then start a new post in this thread and paste it in place.
i want to help me updating my query to update all records at once not only one record .. i attached my data base to check and update query name is // updateStoretransaction //
i want to help me updating my query to update all records at once not only one record .. i attached my data base to check and update query name is // updateStoretransaction //
hi all i want to help me updating my query to update all records at once not only one record .. i attached my data base to check and update query name is // updateStoretransaction // thanks
hi all i want to help me updating my query to update all records at once not only one record .. i attached my data base to check and update query name is // updateStoretransaction // thanks
hi all i want to help me updating my query to update all records at once not only one record .. i attached my data base to check and update query name is // updateStoretransaction // thanks
This implies that you have only one record at a time on the form where you are gathering data. I would say this single-record update behavior is absolutely correct behavior for the combination of the query that you have used and the data sources you are employing. From this particular form, you do NOT want to update all records at once. It will contain only one record's worth of data. There is no justification for making it store data in more than one record at a time.
You insist that the problem is not solved yet. Therefore, we are looking at one of two things happening here. Either
(a) you do not understand some project that you have inherited from someone else or
(b) your description of "not updating every record" doesn't mean to you what it sounds like it means to us, which would imply a language barrier issue.
I am not going to make assumptions either way, but I will categorically state that the problem AS YOU HAVE DESCRIBED IT is totally not possible to fix at any level. The code is not broken.
You opened another thread for this same question. Since you are new, I will simply note the fact that you now have an answer in another thread. However, for future reference, it is perfectly OK to continue a thread. Adding a new post to a thread has the same effect as adding a new thread. In either case, the post makes it to the top of the "New posts" list. You are new and this is a "site etiquette" issue so you can be forgiven.