 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2008Appending all records
Hi - From a "menu" users can choose the region they work. A form opens and filters records for that region from a table which contains all the regions. There can be several people pulling records from this main table but different regions. Once they have done the work needed for each record, the record is then appended to yet another table using a command button which updates the master table. The command button initiates an append query. The problem is that each time someone hits the "append" button, ALL records matching the criteria regardless of the region get appended. How can I limit the records being appended to just the region the user is working? I'd like to be able to use just the one append query and somehow limit the region being updated or should I create an append query for each region? All help is appreciated. Thank you. This depends. Do you have a split database or are the users all sharing the same database. In case of the latter you will always have problems with several options using the same append query. When you have a split db you can create an appendquery for each user because they will have their own frontend. In that case you can reference the combobox in the appendquery something like: in the criteria from the regionfield of the query place: forms!frmname!cboRegion and then you'd have to figure out what to do if people don't choose a region and do click the commandbutton.. etc.  SignatureMaurice Ausum > Hi - > [quoted text clipped - 11 lines] > > All help is appreciated. Thank you. Hi, Maurice - Yes, all users are sharing the same database. So, in this case, would you recommend a separate append query for each region to append to the same master table? Thank you! > This depends. Do you have a split database or are the users all sharing the > same database. In case of the latter you will always have problems with [quoted text clipped - 25 lines] > > > > All help is appreciated. Thank you. That could be an option but it will also mean a lot of maintenance. What if there's a new region? You'd have to create a new query for every added region. But i guess you are stuck because you are still working in one not split db. Give it a try and consider splitting the db that will give you more flexability.. SignatureMaurice Ausum > Hi, Maurice - > [quoted text clipped - 33 lines] > > > > > > All help is appreciated. Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.