Fix access database
$30-250 CAD
Pagado a la entrega
Hi, if you are an expert with VBA, access and word, this project will be very easy for you.
I have a * very small and basic* invoice database with client, invoice and billing tables set up and need some functionality, user interface and reporting added to it:
Functionality
Each "client" entry has multiple invoices and each invoice has multiple billing items to it
1) Each invoice sums and adds HST based on the billing items for that invoice
2) Should be able to add a "credit" billing item
3) Should be able to duplicate an invoice for the current period
4) Which template to merge is determined by the field "useinvoicewithaddress" in the client table - it will merge to a different template location.
5) Invoices have an autoID for access purposes but also an "invoice number" which is a pseudo random generated number. I have the code already for that and will give it to you when you are at that stage.
User interface functionality
1) There should be a box upon opening access that asks "Generate new invoice" with a drop down box of clients and then it will ask me to duplicate a previous invoice
1b) should also be a button to "remerge" the word document and gen the pdf without disrupting anything.
2) When invoice is ready, should be able to push a button to a) merge to a word document template b) convert to pdf and c) email attachment to default mail application. (The merge and pdf vba are already done, no need to do this and will be given to you at that stage)
3) Should be able to select from billing items for that particular client from a drop down box when filling it out (or add a new one)
4) Need to be able to add billing items to each invoice
5) Each billing subform should show only which items are on that particular invoice
6) each invoice subform (in client form) should only show which items are on that particular client
7) I should be able to filter out the invoices as well for each client on the subform for viewing purposes like "all invoices in 2017 etc." then if I double click the invoice, it would bring it up and show me all the billing details
Reporting
1) Should be able to generate reports on a) total $ per year per client and b) total $ per year
I estimate it would take someone with VBA and Access background around 4-6 hours to complete total.
Thank you!
Nº del proyecto: #18301636
Sobre el proyecto
18 freelancers están ofertando un promedio de $191 por este trabajo
Hello, Hope you are doing well. I can help with you in your project Fix access database. I can assure you the quality job. I have good experience in Microsoft Access, Software Architecture, SQL, Visual Basic, Más
hello,how are you. i read your bid carefully. i am c/c++, c# expert and have full experience for 10 years. c/c++, c# is my top skill and i can build your project by using that skills. i can provide most quality and Más
Hi, I'm an expert Access / VBA / database developer with *20 years* experience, and can do the job for you. Please see my Freelancer history for past Access database project reviews. I've reviewed your requiremen Más
Hi, I am a professional MS Access and SQL database developer. I can give you best on this project. Please share your database and see performance. Thank you
Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you add t Más
I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main S Más
Hi there, Greetings! I am glad that I can help you to complete your project with my skills and expertise. I have 10+ years of extensive experience building MS Access and outher relational database. I have excellent d Más
Hello! Nice to meet you. I am a vb expert and have 9 years of experience with vba, sql. I have experience like this project by old employer And I know how to complete your project, and can get this developed for you Más
i have a great command of access, sql and vba, i guarantee a work in a good and due form, contact me through private chat for more details
Hello, everybody! I have developed many mobile applications for 6+ years and I have a rich experience and a great eye for software development. "Best quality, Best speed, Best service", this is my business manner Más
I have on many Access databases and can quickly fix any issues you may have. I love to get on board and that is the reason for my low bid. If you select me, you would not be disappointed. I live in California and can t Más
I can fix your databases cause I have a good experience in access databases and Visual Basic and can make a good interface