Project requires building an access database that can assign a unique identifier of 3 digits after answering questions to put proceeding identifiers - creating a "smart part number". All the questions need to be answered by drop downs to eliminate any variability. There are 7 fields that need to be selected prior to pulling the respective unique 3 digit number at the end that can be pulled sequentially.
Then create a separate form that can be used on users computers that would just be able to look up the respective part number and
This also needs to be set up to have a standalone form that can be used on multiple users' computers that can then run a check on a master list to see if the unique identifier exists. The master list location would be located on a share drive that all users would have access to. Then the use sees the part number and can hit a button to submit and there will be confirmation that the smart number was assigned. Also on the master list it must show that the part number was taken with a date and the user id as shown on computer if possible to drive accountability to what user pulled the part number.
Require a user document on how to make changes if updates need to be made to the questions or outputs in the future. Examples would be to add style codes or other items, or change the dimensions that correspond to the letter.. Project duration - expected completion in 1 week from end of the posting.
The attached file show the first 7 digits and what they correspond to on the selection.
23 freelancers are bidding on average $436 for this job
Hi, I have 12 years experience developing MS Access applications and could do this project for you within a short time frame. Please view my portfolio for some examples of my work.
Dear, I am Access/VBA automation Expert since 10years. I can bring you solution to allow multi-user tool, with your master list. I will be available after development, as support. Regards, Fabrice
Hi, Ms Access expert having 8+ years of IT experience. I have gone through your requirement and will be able to help you in developing the application. Please see your PM for more details.