Fix access database

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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!

Microsoft Access Software Architecture SQL Visual Basic Visual Basic for Apps

Project ID: #18301636

About the project

18 proposals Remote project Active 5 years ago

Awarded to:

WaseemSh

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 More

$135 CAD in 1 day
(5 Reviews)
3.2

18 freelancers are bidding on average $191 for this job

schoudhary1553

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

$250 CAD in 4 days
(310 Reviews)
8.2
ITPyramid85

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 More

$150 CAD in 3 days
(26 Reviews)
6.9
fabest

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 More

$133 CAD in 3 days
(93 Reviews)
7.4
expertcoder1vw

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 More

$400 CAD in 7 days
(103 Reviews)
6.7
VBAautomation

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 in 1 day
(33 Reviews)
5.8
alaeddindhahri

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 More

$200 CAD in 3 days
(72 Reviews)
5.9
akritisood94

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 More

$155 CAD in 3 days
(59 Reviews)
5.8
rayyankabir

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 More

$250 CAD in 5 days
(22 Reviews)
5.0
Weebside

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 More

$200 CAD in 1 day
(50 Reviews)
5.0
wuricheng1985

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 More

$100 CAD in 3 days
(5 Reviews)
3.7
mihrimahe

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 in 1 day
(1 Review)
3.4
pnjadhav

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 More

$250 CAD in 5 days
(5 Reviews)
3.4
andreiwasiliv

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 More

$155 CAD in 3 days
(2 Reviews)
1.2
semetay

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 More

$250 CAD in 3 days
(0 Reviews)
0.0
DBDeveloper1

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 More

$100 CAD in 3 days
(0 Reviews)
0.0
amrtahadesign

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 days
(0 Reviews)
0.0