I have a spreadsheet that contains tons of data related to our shop's inventory: part numbers, vendor info, pricing, etc... I need that spreadsheet to be turned into Access Tables as needed and then a form created that allows me to look up inventory items via any of several fields and edit information for that line item and save. I also need a form that allows me to look up line items by any of various fields and then enter a quantity and have that quantity of that particular line item added to a BOM (bill of materials). Basically we build assemblies and know that it takes 7 of line item X and 9 of line item Y and 12 of line item Z to make one assembly...so we need to be able to select those and have the ability to either print that BOM or export it to an Excel spreadsheet at the end...preferably both. This should be very similar to an Order / Order Details form / subform setup...I just haven't played with Access enough in recent years to remember how to do the look up queries, etc...so I prefer to sub it out. I have attached a sample Excel spreadsheet that has the fields for the inventory. When looking up inventory line items, I would like to sort by category then sub-category to get me closer to the item that I am looking for. The final BOM report should have room for a Project Name, customer contact information, then a list of all the line items included in the BOM with extensions of the price and cost per line item as well as a total price and cost for the whole BOM at the bottom. I need this done by Sunday 4pm PST...so if you can't do it by then please don't bother bidding. It should be really quick and pretty simple. Nothing fancy in appearance...just need the functionality.
Hi David, I've just finished a similar inventory application with import and export facilities for another client. Please read my private message for the details of the bid. Regards, Steve.
21 freelancers are bidding on average $178 for this job
Hi, I have made many similar programs in Access. I ll send y a demo where y can find the functionality of BOM already working. It might need little tweaking to match yr needs.
Good morning. I have over 15 years of experience building Access databases. I am available to start immediately. Please check your PMB. Thanks for the consideration. Best regards.
Hello, I can develop your application on your requirements, Freelance With 10 Years Of Experience In Developing Applications On Ms Access For Small, Medium And Large Companies For Public Or Private Sector.