A checklist using form option

%3CLINGO-SUB%20id%3D%22lingo-sub-799432%22%20slang%3D%22en-US%22%3EA%20checklist%20using%20form%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799432%22%20slang%3D%22en-US%22%3EThis%20is%20a%20process%20in%20which%20mechanical%20parts%20are%20listed%20in%20an%20excel%20sheet.%20Each%20part%20will%20be%20reviewed%20by%202%20reviewers.%20Both%20the%20reviewers%20names%20will%20be%20present%20along%20with%20the%20part%20number%20in%20the%20excel.%20There%20are%20a%20set%20of%20steps%20both%20the%20reviewers%20have%20to%20follow%20which%20have%20been%20listed%20in%20a%20checklist.%20They%20have%20to%20tick%20against%20that%20step%20in%20the%20checklist%20after%20performing%20that%20operation.%20The%20checklist%20is%20a%20hardcopy%20and%20has%20to%20be%20stored.%20I%20want%20to%20make%20this%20process%20electronic%20by%20creating%20a%20database%20for%20the%20parts%20in%20access%20and%20link%20each%20part%20to%20a%20checklist%20template%2C%20created%20by%20using%20the%20form%20option%20in%20access.%20The%20reviewers%20for%20that%20part%20will%20have%20access%20to%20that%20checklist%20while%20reviewing%20that%20part%20and%20have%20to%20fill%20it.%20This%20checklist%20should%20have%20shared%20entries%20from%20both%20the%20reviewers.%20Is%20this%20possible%20in%20access%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-799432%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-799658%22%20slang%3D%22en-US%22%3ERe%3A%20A%20checklist%20using%20form%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799658%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F390660%22%20target%3D%22_blank%22%3E%40vmskrshn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20it%20is%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20create%20a%20form%20with%20a%20subform.%20The%20form%20contains%20the%20parts%2C%20the%20subform%20the%20checklist.%20Point%20is%20that%20you%20need%20a%20few%20procedures%20to%20check%20if%20the%20%22required%20fields%22%20are%20filled%20in%20or%20not.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20say%20it%20is%20not%20a%20job%20for%20a%20beginner%20in%20Access.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreetings%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMarcel%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor
This is a process in which mechanical parts are listed in an excel sheet. Each part will be reviewed by 2 reviewers. Both the reviewers names will be present along with the part number in the excel. There are a set of steps both the reviewers have to follow which have been listed in a checklist. They have to tick against that step in the checklist after performing that operation. The checklist is a hardcopy and has to be stored. I want to make this process electronic by creating a database for the parts in access and link each part to a checklist template, created by using the form option in access. The reviewers for that part will have access to that checklist while reviewing that part and have to fill it. This checklist should have shared entries from both the reviewers. Is this possible in access?
1 Reply
Highlighted

@vmskrshn 

Yes it is possible.

 

You can create a form with a subform. The form contains the parts, the subform the checklist. Point is that you need a few procedures to check if the "required fields" are filled in or not. 

I would say it is not a job for a beginner in Access. 

 

Greetings,

 

Marcel