Results 1 to 8 of 8
  1. #1
    Miyatake is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    3

    Access 2016-Creating main Work Order form with ability to enter multiple jobs


    I have Access 2016. I would like to create a database form that will tie multiple job order entries to a single work order table. How do I do that?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,921
    Have you looked at any of the Templates for MS Access yet?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    Miyatake is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    3
    Yes. None fit my exact needs

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,921
    Are any "close" to what you want because they should be pretty easy to tailor to your exact needs.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  5. #5
    Miyatake is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    3
    I will look again but I have done this before but it was so long ago that I cannot remember how I did it

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,921
    It is *much* easier to modify an application that is "close" to what you need than create one from scratch. There are plenty of helpers on this forum that would be glad to help if you get stuck on something.
    Good luck with the project.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  7. #7
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    8,790
    Did those suggested models not have a work order table linked to some other table (e.g. work order task)?? This seems pretty basic. Wondering why they didn't meet your needs.
    There are several supporting tables that you could link to a work order table: task comments, completion comments, approval comments, task order parts, costing, etc.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  8. #8
    BibleResearchTools is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2018
    Posts
    1
    Quote Originally Posted by Miyatake View Post
    I have Access 2016. I would like to create a database form that will tie multiple job order entries to a single work order table. How do I do that?
    See if this helps:

    Click image for larger version. 

Name:	WorkOrder Table Structures.png 
Views:	12 
Size:	18.8 KB 
ID:	33981

    Click image for larger version. 

Name:	WorkOrder Relationships.png 
Views:	12 
Size:	13.6 KB 
ID:	33982

    Click image for larger version. 

Name:	frmJob.png 
Views:	12 
Size:	19.3 KB 
ID:	33986


    Embed frmJob into frmWorkOrder Detail

    Click image for larger version. 

Name:	frmWorkOrder.png 
Views:	12 
Size:	24.9 KB 
ID:	33984


    This is the Employee Query to populate the EmployeeNo/Supervisor Combo Boxes.


    Click image for larger version. 

Name:	Employee Number Query.png 
Views:	12 
Size:	45.9 KB 
ID:	33985

    Dan

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 05-18-2018, 12:38 PM
  2. Replies: 9
    Last Post: 10-23-2017, 12:46 AM
  3. Replies: 3
    Last Post: 03-17-2017, 08:00 AM
  4. Replies: 2
    Last Post: 03-07-2017, 04:00 PM
  5. Replies: 2
    Last Post: 06-18-2012, 03:33 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 - Senior Forums