Home

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
vmskrshn
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

@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 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies