I'm hoping someone can tell me if the SDK will allow me to do this...
I want to identify which employee has done a specific task. There are about a dozen operations to perform on each unit that goes through my department. Sometimes one person works alone and performs all of the operations, sometimes it's two or even three working on the same unit.
There are also multiple shifts. Right now we use a paper checklist to track who did which operation on each unit - each employee initials a box for each operation on each unit.
I'm sure it's obvious why this isn't a great method! What I'd like to do is replace the paper checklist with a database (probably Access) that keeps track of the data, allowing us to track completion status online and more easily address quality issues. The easy solution is to have a table with a record for each unit, and a field for each operation where the employee would enter their "initials" (or whatever ID method we want to use).
Problem is, this is a very cumbersome replacement for a quick swipe of the pen! What I envisioned was having each employee select checkboxes for the operations they did on a particular unit, then be prompted to swipe their finger to identify themselves and send their ID to the marked fields in that record.
My questions are:
- Can I even do this? There's so much on this site about using the SDK to develop complete applications, or launch applications, etc, and about using Access to store enrollment info ... but I'm not sure (probably not savvy enough to figure out!) if it will supply the ID info TO Access for use WITHIN Access.
- Will VBA be able to process the ActiveX controls within Access, or do I HAVE to use Visual Studio and process all of this outside of Access.
And finally, since I'm not a professional programmer - I've gotten into some VB programming to get Access and Excel to jump through some hoops, but I'm by no means a pro - is this a learning curve I even want to start climbing? Thanks in advance for any advice and opinions you may have!