I need to be able a custom ACCESS tool for inventory. Let me walk you through what I envision.
I have two tables with information:
Table 1: Employee ID Number (Name, Last Name, Hired Day, ID Number)
Table 2: Inventory ID (Inventory number, details)
The employee scans his/hers bar code number. Access looks up the person in Table 1 and based on that it populates the name of the person (name and last name). Access gives you THREE options to follow up that:
A) NEW CHECKOUT B) RETURN C) REPORT A PROBLEM
If the person clicks on "A" "NEW CHECKOUT." The person then is prompted to scan the barcode on the product. Access looks on Table 2 Inventory ID. and matches that number with the product. The product CAN'T already be checked out, and times stamp the [url removed, login to view] creates a list (Table 3) of the product that was checked out, with the following information:
RESULT from A): Employee ID Number, Name, Last Name, Day and Time Checked out (all this recorded on Table 3).
If the person clicks on "B" "RETURN" The person then is prompted to scan the barcode on the product. Access looks on Table 3 Inventory ID. and matches that number with the product that was already checked out. The product CAN'T be checked in if it was not checked out and records the time stamp of the transaction.
RESULT from B): adds this information to (table 3) in the respective field. OR creates "table 4" that records returns. If "table 4" is created, I need to be able to run a report that shows me all the checked out products and the returned products, names, last names time stamps of both actions.
If the person clicks on "C" "Report a Problem" The person is prompted to write a paragraph of the issue. There should be a field for Inventory ID. So the person can report that a specific inventory had some problem or some other note. The inventory ID is not a mandatory field.
Reports that I need to be able to create:
Report 1: Every Week product: run all the checked out products not returned and count days since checked out. Need the report to clarify that the report is updated as of (day when run).
Report 2: Number of products checked out and returned per employee. Need the report to clarify that the report is updated as of (day when run).
Report 3: (read below to fully understand this one). Be able to create a report based on Inventory ID. Lets just say, that location 1, has inventory from 00011 to 00200. Then I want them to just be able to run reports on their Employees, and who didn't return a list, who has, and how many everybody has done (same as Report 1 and 2 but for the current location).
Report 4: report per location. With that just names each report w a title of the location (North, South, SLC, SLC2, VOLUNTEER). So we can see the same info per each of those.
I need to be able to use barcode bars, and also I need to be able to type the numbers in case the bar code is not working. I need the part of the form that asks for the three options: A) NEW CHECKOUT B) RETURN C) REPORT A PROBLEM be simple to use, clean and sort of pretty. Hopefully. no need for scrolling or TAB but that can be arranged.
I envision this to be on a computer next to the inventory pile, and run from there, but there is a chance that I will need this to run from ACCESS online web tool. Because I may have 4 locations using the same Tables 1 and 2, and I need to be able to pull Table 3 (and 4 if is there), and I need to be able to run reports Report 1 through 4 from home base (SLC).
I hope I explained this clearly. Let me know if you have any questions.
I am not opposed to have a web tool (as long as I can password protect it). I don't want to compromise my lists.
Bu iş için 26 freelancer ortalamada $321 teklif veriyor
Hello, I can give proposal for webtool with access protection, Please let me know if i am in your shortlist - i can submit my detailed proposal. Thanks, Sathies
Dear Project Manager, Greeting from Votive Technologies!! I just came across this requirement and wanted to have a brief conversation with you on the subject. We are the expert WordPress Development and Desig Daha Fazla
Hello, my name is Olya. I represent Ukrainian IT Company «Webbook». We provide website design and web and app development services for organizations, public and government institutions, company or private web-pages. Daha Fazla
SALUTATION Hello Dear, We initially started our startup with 5 clients and 10 team members. Today after 8 years, we have over 224 satisfied clients and 41 members in our team. Our main focus is on to bui Daha Fazla
Hi, I am interested to work with you on this project, I reviewed the requests you listed and I would like to discuss further details with you. Since 2006 I am managing a Web Design Agency located in Romania, which cur Daha Fazla
Hello sir, I have reviewed your requirement and after understanding it well excited to work with you on your awesome concept.I would really love to speak with you further regarding this project, so kindly come in pm Daha Fazla
Hello, I have gone through your outsourced requirements "Write some Software " and have analyzed that I have right skills (PHP, Software Architecture) to execute your esteemed project. I will complete your projec Daha Fazla
Hi Let's clarify the requirement in details also if you want us to share our previous work let us [login to view URL] have a few questions about your project, please send us message so that we can discuss more. Thanks & reg Daha Fazla
Thank you for your interest in partnering with Hitaishin infotech for your website development project. With well over 100,000 firms offering website development services, we know how challenging it can be to find th Daha Fazla
I am Yogesh sanwal, 5+ years experienced in website and e-commerce development using PHP/MySQL and Internet Marketing. Take a look to my last work: [login to view URL] [login to view URL] http: Daha Fazla
Hi, This is angel from [login to view URL] We could provide a Software. We are a company located in India. Give us one good chance to provide our ability. See our recent website works [login to view URL] https: Daha Fazla
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Daha Fazla
Hi, I am well equipped to this kind of task and can handle it pretty well. In fact, I already done job related to this before. Let me know the best of your time so we can discuss further based on your requirements and Daha Fazla
Dear Sir, I am based out of Jersey City, NJ, USA. Completed numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. You can refer my freelancer profile for reviews and Daha Fazla
Hi, I can do it using java / mySQL. It would be a mobile / web application. The barcode reader acts like a normal keyboard, se there is no much concern about the scan. I need to know which kind of bar code you need ( Daha Fazla
Hey, Greeting of the day, I am konika. I was looking through your project requirements and I do believe it's something we have experience in previous development and we can complete in a reasonable amount of time and Daha Fazla