Fix access database

Job Description:

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:


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


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!

Habilidades: Microsoft Access, Arquitetura de software, SQL, Visual Basic, Visual Basic para Apps

Sobre o Cliente:
( 218 comentários ) Mississauga, Canada

ID do Projeto: #18301636

Concedido a:


Hello, My name is Waseem, I'm expert in MS Access and VBA and have more than 10 years experience in building and developing MS Access Applications, I read your project completely and found myself able to accomplish the Mais

$135 CAD em 1 dia
(5 Comentários)

18 freelancers estão ofertando em média $191 nesse trabalho


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, Mais

$250 CAD in 4 dias
(310 Comentários)

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 Mais

$150 CAD in 3 dias
(26 Comentários)

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As Mais

$133 CAD in 3 dias
(93 Comentários)

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 Mais

$400 CAD in 7 dias
(103 Comentários)

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

$200 CAD em 1 dia
(33 Comentários)

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 Mais

$200 CAD in 3 dias
(72 Comentários)

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 Mais

$155 CAD in 3 dias
(59 Comentários)

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 Mais

$250 CAD in 5 dias
(22 Comentários)

Hello, I am a professional software engineer. I have read the description and I would like to work for you. For further details please inbox me. Thank you so much. Having Perfect Expertise in Required Programming Lan Mais

$200 CAD em 1 dia
(50 Comentários)

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 Mais

$100 CAD in 3 dias
(5 Comentários)

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

$200 CAD em 1 dia
(1 Comentário)

Please review my profile I am working with skills that you required for this job from 16 years. I am working with MS Access,Excel,MS SQL and VBA from long time. I can definitely help you in this job, to make your d Mais

$250 CAD in 5 dias
(5 Comentários)

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 Mais

$155 CAD in 3 dias
(2 Comentários)

I have 20+ years of MS Access experience combined with VBA. I wrote many applications featuring invoice, order, stock management and reporting with multiple user access. I read your requirements. I can fix and add fe Mais

$250 CAD in 3 dias
(0 Comentários)

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 Mais

$100 CAD in 3 dias
(0 Comentários)

I can fix your databases cause I have a good experience in access databases and Visual Basic and can make a good interface

$277 CAD in 5 dias
(0 Comentários)