Page 1 of 3 123 LastLast
Results 1 to 15 of 37
  1. #1
    FlabbyRoach is offline Advanced Beginner
    Windows 8 Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    48

    Multiple Operations for a Job Order

    I am working on a simple database where I can enter and order job number and give it multiple job operations.
    I have set up a table with the operation numbers and operation descriptions.
    I have a form I made to enter the information but when I tab thru the boxes it wants to add another job number when I get to the end.
    Is there a way to enter multiple operations and descriptions for one job number?


    Thanks

  2. #2
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    Without knowing your form design this answer may not be accurate. To stop Access from advancing to the next/new record when using the Tab key on the last control, change the Form "Cycle" property on the "Other" tab to "Current Record".

  3. #3
    FlabbyRoach is offline Advanced Beginner
    Windows 8 Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    48
    OK, so maybe I should word it this way.
    I would like to add additional processes to one job.
    Or should this be a query question?

  4. #4
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    It's impossible to provide constructive advice without seeing your database.

  5. #5
    FlabbyRoach is offline Advanced Beginner
    Windows 8 Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    48
    Process Sheet.pdf
    This is what I am after
    I am not sure how to show you the database.

  6. #6
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    I take it there are three tables - one for SO numbers, one for Op numbers and one which holds all the items for each SO. Then, you will have a main form for the SO table where you enter the SO# and a subform for the Item table where you enter the items, with Op# being a combobox.

    Where is it adding another job number?

  7. #7
    FlabbyRoach is offline Advanced Beginner
    Windows 8 Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    48
    Yes, there are three tables; one for Operation Numbers; one for Operation Description and one to hold all the items for each SO.
    The SO number table is what i used to make the form.
    Hopefully, that table will hold all the information for each individual SO # that I need.
    I am more interested in trying to add additional operation numbers and description into my form.
    If that is possible.

    this is the table for the SO
    SO# Description Quantity Delivery Date Operation Number Operation Description Time Each Total Time
    123123 pull broch 6 3/31/2017 216 Turn Button(s) Front Pilot & Teeth 0.235 1.41
    Last edited by FlabbyRoach; 03-29-2017 at 12:04 PM. Reason: added table for clarity

  8. #8
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Your form should look exactly like the pdf you attached - the main form with the top holding the SO # and the subform beneath - it should be a continuous form and you can add as many operations as you desire.

  9. #9
    FlabbyRoach is offline Advanced Beginner
    Windows 8 Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    48
    Quote Originally Posted by aytee111 View Post
    it should be a continuous form and you can add as many operations as you desire.
    I guess that is what I was getting at.
    Do I add more operations by adding more fields?
    Or can I use the same field to add multiple operations?
    How do I show you my form?

  10. #10
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Open your form in design mode and go to its properties: Default View must be Continuous and Cycle must be All Records. Then it will look like your pdf. It may be better to start your subform again from the beginning, using the wizard and set it to Tabular.

  11. #11
    FlabbyRoach is offline Advanced Beginner
    Windows 8 Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    48
    OK, I will try that
    Thanks

  12. #12
    FlabbyRoach is offline Advanced Beginner
    Windows 8 Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    48
    OK sorry for this
    Attached Thumbnails Attached Thumbnails Process Sheet Form.pdf.jpg   Process Sheet Form.pdf.jpg  

  13. #13
    FlabbyRoach is offline Advanced Beginner
    Windows 8 Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    48
    OK, Here is what I have now.
    Do I add as many fields as I need or does the form automaticaly add the next line?
    Attached Thumbnails Attached Thumbnails Process Sheet Form.pdf.jpg  

  14. #14
    FlabbyRoach is offline Advanced Beginner
    Windows 8 Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    48
    Disregard post #12

  15. #15
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Where is the subform? You need main form for header info (SO#, etc) and subform for details (Op#, etc). Two separate forms.

Page 1 of 3 123 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 03-07-2016, 05:02 PM
  2. switchboard operations
    By Deb4566 in forum Access
    Replies: 1
    Last Post: 03-15-2013, 04:16 PM
  3. What is routine database operations?
    By gaosanyong in forum Access
    Replies: 1
    Last Post: 12-13-2012, 02:40 PM
  4. Operations Between Records on a Table
    By swicklund in forum Queries
    Replies: 3
    Last Post: 03-27-2012, 01:42 PM
  5. Replies: 3
    Last Post: 05-15-2011, 11:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums