I work in a company where we buy with order forms (on paper). When I want to order something with a company, I've got to fill in such a paper: the coordinates of the company, the delivery adress, the parts you want to buy with their price and finally the total price. This system becomes really hard the moment I've got to order several times with the same company. Each time I've to write down the same company info.
So I've improved the system by working with excel. When I make a command with the same company I make a copy of an existing command form and make my changes.
Until now this system worked perfectly, but now I've got to control my budget. So I create an Access Database wherein I store the ordering info (company info, number of order form, total price, date, delivary delai,...) everything but the productinfo, because of the enormous varity of products
MY QUESTION now!!! I want to create an access tool in which I enter my order info (including the company info) Afterworths I push on some button and an excel sheet is created where all my info is already filled in. So I have to enter just my product info on my excel sheet and copy the total price on my Access databank and my work is done.
Is this possible and how is it possible?
When this should work I would extend this system to fill in the headings of my faxes and my letters...
So I've improved the system by working with excel. When I make a command with the same company I make a copy of an existing command form and make my changes.
Until now this system worked perfectly, but now I've got to control my budget. So I create an Access Database wherein I store the ordering info (company info, number of order form, total price, date, delivary delai,...) everything but the productinfo, because of the enormous varity of products
MY QUESTION now!!! I want to create an access tool in which I enter my order info (including the company info) Afterworths I push on some button and an excel sheet is created where all my info is already filled in. So I have to enter just my product info on my excel sheet and copy the total price on my Access databank and my work is done.
Is this possible and how is it possible?
When this should work I would extend this system to fill in the headings of my faxes and my letters...
