Hi all,
I run an AV rental company and right now we keep track of the stuff going in and out with an excel sheet with days on the x-axis and the products (plasma screen 42" 1; plasma screen 42" 2; plasma screen 42" x; plasma screen 50" 1; plasma screen 50" 2; .....) on the y-axis, so that we know exactly if the equipment is or if it's out we know where it is (we write the name of the customer and the name of the exhibition where we will be installing the stuff in the cell).
We use another excel file for every exhibition to give to the technicians for the preparation of the equipments (the first sheet) and for the installation (the other sheets).
The first sheet is a list of the customer on the y-axis, the name of the products on the x-axis and the number of the specific product the customer wants in the cross cell.
The other sheets are one for each customer, automatically filled in with the name of the customer from sheet 1 and all the products he wants (always from sheet 1).
I now want to automate this process all in one in an access DB so that I just have to insert the name of the customer and what he wants and access has to automatically check if the products are available and create the 2 sheets mentioned before (for equipment preparation and for the installation).
I know I may have not been that clear...sorry about that, but I can provide, to who is interested, some examples for a better understanding.
Waiting for you.
Regards,
Andrea
Hi there,
I do have a similar business and developed a tool to manage this and am very happy to share this application with you.
My program has a strong reporting tool as well.
Regards
I have built databases and spreadsheets as a daily part of my job for over 10 years. This would be a great use of Access and I know I can produce a tool that will significantly improve your business process. One of my specialties is reviewing business processes and creating automations tools to simplify them.
Dear Manager,
I have a long experience on Access 2003-2010. Please provide your requirements. I am capbale to finish your project in time.
Thank you, Kazi
hi
I have ten years experience on MS Access.
I have done serven Access DB for client in 2009
also I have five years in MS Access 2003 and Access 2007
I am sure I can do it well.
Let us start now.
look forward to your reply.
Btw: I were MVP about Mircosoft Access in 2003
Zhi Zhang