steel_lady
02-19-2008, 07:50 AM
I am new at this work and I have to control the production in the company. Since I don't have any experience with VBA I put down our necesities so I need your help telling me for every part of the project what do I have to use to accomplish it, hints like:
This part you do in access (hint: xxx comand) , that part you do VBA script (first I don't know where to put in VBA scripts) etc.
I need to know all the components that I need for this and how to connect them, then I will take the resources and search how to do it specifically. So I need all the general hints you can give me here because I am starting from zero. If you want to see excel sheets mentioned, tell me where to upload them. Many thanx!
_______________________________________
To run the company production:
1) - Database of the planning calendar through the year
- The screen would contain the planning per chosen week
- Inside the every day of the week I would choose the time
intervals for some particular installation and assign it to some of the technicians listed while at the same time period I can assign the other instalation to other technicians.
- For every of these installations I need to mark if
a) we received the written report on it
b) has that part of the work been evaluated
c) is the proyect finished
d) do we have some special material needed to finish it
(marking that we have special requeriments and then put the text comment)
- being able to search for (un)finished proyects, pending special needs, proyects with the report missing or not evaluated.
I have already prepaired the default Excel workbook 'Parted.xls' for every daily part of project installation Where you enter the hours and the material and it calculates various costs and the rentability of that part of the installation.
So, I would like that, when I enter the name of the installation in my planner, the script makes a copy of the default workbook, changing its name to the name of the client with the date that I assigned it to.
If I mark that the installation is finished, I need a script that takes the other Excel workbook that I have also prepared, 'Project.xls' , adding as many copies of the first row as there are separate Installation_date.xls (versions of 'Parted.xls') workbooks, renames all those files to finished_Installation_date.xls and inside the ProyectX.xls puts the links to all those corresponding cells of the finished_installation_date.xls files so that the 'Project' calculates the total cost of all finished_Installation_date.xls files together.
2) When the project is finished, I would execute another script that would add that data taken from the Project workbook to the second database which would contain :
- The name of the client
- The mediator
- The duration of the project
- The amount charged
- Our benefit from the project
3) The third database would be the database of items containing:
- Our reference for the item
- Descriptive name
- Long description
- The market price
- The make
- The provider
- The discount the provider gives us
- The second provider
- The discount of the second provider
- The manufacturer's reference
Upon every database change, another script would do the actualization of the Excel workbook containing the complete list of items with the fields of our reference, descriptive name, market price, discount, and the manufacturer's :wotreference.
This part you do in access (hint: xxx comand) , that part you do VBA script (first I don't know where to put in VBA scripts) etc.
I need to know all the components that I need for this and how to connect them, then I will take the resources and search how to do it specifically. So I need all the general hints you can give me here because I am starting from zero. If you want to see excel sheets mentioned, tell me where to upload them. Many thanx!
_______________________________________
To run the company production:
1) - Database of the planning calendar through the year
- The screen would contain the planning per chosen week
- Inside the every day of the week I would choose the time
intervals for some particular installation and assign it to some of the technicians listed while at the same time period I can assign the other instalation to other technicians.
- For every of these installations I need to mark if
a) we received the written report on it
b) has that part of the work been evaluated
c) is the proyect finished
d) do we have some special material needed to finish it
(marking that we have special requeriments and then put the text comment)
- being able to search for (un)finished proyects, pending special needs, proyects with the report missing or not evaluated.
I have already prepaired the default Excel workbook 'Parted.xls' for every daily part of project installation Where you enter the hours and the material and it calculates various costs and the rentability of that part of the installation.
So, I would like that, when I enter the name of the installation in my planner, the script makes a copy of the default workbook, changing its name to the name of the client with the date that I assigned it to.
If I mark that the installation is finished, I need a script that takes the other Excel workbook that I have also prepared, 'Project.xls' , adding as many copies of the first row as there are separate Installation_date.xls (versions of 'Parted.xls') workbooks, renames all those files to finished_Installation_date.xls and inside the ProyectX.xls puts the links to all those corresponding cells of the finished_installation_date.xls files so that the 'Project' calculates the total cost of all finished_Installation_date.xls files together.
2) When the project is finished, I would execute another script that would add that data taken from the Project workbook to the second database which would contain :
- The name of the client
- The mediator
- The duration of the project
- The amount charged
- Our benefit from the project
3) The third database would be the database of items containing:
- Our reference for the item
- Descriptive name
- Long description
- The market price
- The make
- The provider
- The discount the provider gives us
- The second provider
- The discount of the second provider
- The manufacturer's reference
Upon every database change, another script would do the actualization of the Excel workbook containing the complete list of items with the fields of our reference, descriptive name, market price, discount, and the manufacturer's :wotreference.