Microsoft Access Developer - amendments to exisiting database
4619
£450(approx. $563)
- Posted:
- Proposals: 5
- Remote
- #85858
- Archived
Description
Experience Level: Expert
We have an existing Microsoft Access database running via an .exe runtime. We have the original Access files and require further development to this small database.
The system is very simple and allows us to produce Delivery Notes with the following fields:
Note Number
Date
Company Name - via drop down from the database
Address - via database
Order Number - manually entered
Instructions - manually entered
Product Code - via drop down from the database
Quantity - manually entered
Description - auto entered from the database based on product code
There are then the options to: Close/Save/Print Note
The note prints x 3 times on different coloured paper. The paper is stacked in the printer accordingly.
The system saves completed delivery notes within the database.
We can edit company details and product details within the database.
We have the following problems and would like the following additions:
Address doesn't always print out. For example, it will not print unless the address box is clicked. If you enter the necessary information to into the delivery note INCLUDING the address you can see it on screen but it doesn't print.
Occasionally, if you start a delivery note then leave it - return to it - it can simply disappear off screen and a new note number is generated.
If you go back to edit a delivery by adding some new items on screen, they appear at the bottom of the delivery note but when you print them they can be rearranged and no longer appear at the bottom of the delivery note.
Product viewing field is not long enough to view all of the numbers.
Description fields are not long enough to enter all information.
Initial entry onto the delivery note allows up to 15 lines per note. However, on returning to edit the lines are bigger than normal (in spacing) so that there is only x12 lines per delivery note. Lines 13,14,15 appear on screen and you can type the entries - but when printed out they disappear and don't print out.
Please add the facility to look up delivery notes by customer.
Please update old logo to new design.
Layout must stay the same - the delivery notes are printed onto x3 copies where the new logo is preprinted and the information fits exactly now.
If you require any further information, please don't hesitate to contact me. The original Access files will be provided.
Best Regards,
Peter
The system is very simple and allows us to produce Delivery Notes with the following fields:
Note Number
Date
Company Name - via drop down from the database
Address - via database
Order Number - manually entered
Instructions - manually entered
Product Code - via drop down from the database
Quantity - manually entered
Description - auto entered from the database based on product code
There are then the options to: Close/Save/Print Note
The note prints x 3 times on different coloured paper. The paper is stacked in the printer accordingly.
The system saves completed delivery notes within the database.
We can edit company details and product details within the database.
We have the following problems and would like the following additions:
Address doesn't always print out. For example, it will not print unless the address box is clicked. If you enter the necessary information to into the delivery note INCLUDING the address you can see it on screen but it doesn't print.
Occasionally, if you start a delivery note then leave it - return to it - it can simply disappear off screen and a new note number is generated.
If you go back to edit a delivery by adding some new items on screen, they appear at the bottom of the delivery note but when you print them they can be rearranged and no longer appear at the bottom of the delivery note.
Product viewing field is not long enough to view all of the numbers.
Description fields are not long enough to enter all information.
Initial entry onto the delivery note allows up to 15 lines per note. However, on returning to edit the lines are bigger than normal (in spacing) so that there is only x12 lines per delivery note. Lines 13,14,15 appear on screen and you can type the entries - but when printed out they disappear and don't print out.
Please add the facility to look up delivery notes by customer.
Please update old logo to new design.
Layout must stay the same - the delivery notes are printed onto x3 copies where the new logo is preprinted and the information fits exactly now.
If you require any further information, please don't hesitate to contact me. The original Access files will be provided.
Best Regards,
Peter
Charlie E.
99% (30)Projects Completed
34
Freelancers worked with
27
Projects awarded
41%
Last project
24 Jul 2014
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies