 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / December 2007Need a button to update a table
I am trying to create a form that a mechanic in a factory can acces, type in the part number - suffix of a part and assign it to a production line. I have a table (PartSuffixTbl) that includes PartNumber and Suffix that are entered through an administration form. (The mechanics have to only access this information and are not allowed to change it.) The table also includes a field for Line. (This is the field I have to update) I have created a query(Part-Suffix Query) that combines the PartNumber and Suffix to display as one field PartNumber-Suffix (Expr1). I have created a form with 10 combo boxes and set the row source for each of the of these as the Part-Suffix Query.Expr1 and included hidden fields for both PartNumber and Suffix. (This is to give the mechanic the possiblity of adding 10 parts to a line at one time) I have also created an unbound text box with a row source to another table that lists all availabe line numbers. I hope this is the correct beginning for what I want to do, which is, I want to create a button that when clicked adds the line number to the PartSuffixTbl for each of the 10 (or less) PartNumber-Suffix(s) selected in the combo boxes. Sure hope I stated that clearly enough to get some help. Thanks in advance. I guess I don't understand the problem. Your requirement seems simple enough. May I assume that "lines" become available or unavailable through some real-time emchanism? If so, how would you get that information into your database in a timely manner? If not, what makes a line available (or not)? The actual mechanics of adding a line to the table entry are pretty trviail; the underlying issues I outlined being more complex by far. Dennis The mechanics are removing the parts from the stock room and putting them on an assembly line. They physically have the parts in hand when the do the assignment. Not sure if that answers your question. BUT in the meanwhile I was able to solve the issue (or seemingly so) with a "DoCmd.RunSQL" statement on the button > I guess I don't understand the problem. Your requirement seems simple enough. > [quoted text clipped - 5 lines] > > Dennis Well, you talk about an "available line." How do you/they know which line would be available at any given time? (FYI, my primary expertise is in heavy manufacturing real-time automated data-collection and control systems, so I approah your questions from that perspective.) > The mechanics are removing the parts from the stock room and putting them on > an assembly line. They physically have the parts in hand when the do the [quoted text clipped - 12 lines] > > > > Dennis Assembly line > Well, you talk about an "available line." How do you/they know which line > would be available at any given time? (FYI, my primary expertise is in heavy [quoted text clipped - 17 lines] > > > > > > Dennis I understand. But you haven't yet told me how you know what line to assign a part to? How do you know what line is available for the part at the time it's picked? THAT answer will determine how you assign the line to the record. Thanks, but I have solved that problem, now I am on to another. > I understand. But you haven't yet told me how you know what line to assign a > part to? How do you know what line is available for the part at the time it's > picked? THAT answer will determine how you assign the line to the record. |
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.