help me to build an invoice function in ms access

I have a simple ms access database. I need help to create an invoice function within the database.

The table named "time-log-worked-for-various-organizations_tbl" contains a log which is imported monthly from an excel worksheet. This contains records for when, where and what job was performed for what customer and how much pay was aggreed for each job done.

I need a form where I can select a customer, start and end date from the log, and this information should pull the information from the log and generate an invoice.

The invoice itself should contain information that you will find in the design view of the "invoice_tbl"

I will also need a table and a form to record received payments. Please see the table "Payments-received_tbl" for this.

Then at last, I will need a report that can retrieve a list of balances (outstanding payments and payments received) in order to keep track of any unpaid invoices.

I tried to do this myself but I could not get it to work.

Please see the uploaded database. It contains dummy data. When your work is completed, I intend to copy and paste the forms/macros/tables..etc into my real live database.

Skills: Database Programming, Microsoft Access, Visual Basic

See more: help build website, email function using access, help build recruitment website aspnet, microsoft access templates for invoice tracking, microsoft access 2010 invoice database, invoice database design, microsoft access receipt template, ms access invoice database tutorial, microsoft access billing template, invoice format in access 2007, how to create a billing software in ms access 2007 pdf, example access database invoices, function return access 2007, access form invoices multiple products download, access help compare date query design view, let help build coupon website, find function microsoft access, microsoft word automation invoice vba microsoft access, build pos ms access, function inserting data ms access desktop application

About the Employer:
( 2 reviews ) Matsuyama, Japan

Project ID: #18832373

35 freelancers are bidding on average $167 for this job


Hello! I can help you add invoicing functionality to your database. I will try to do it without VBA coding, but if that is required, would you mind if I use some VBA? About the timeline, I think this will take no More

$155 USD in 3 days
(227 Reviews)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$250 USD in 3 days
(152 Reviews)

Hello, I am experienced MS Access developer and I can complete your application. I reviewed the attached file and I don't see any issues based on your requirements. I would only need more info about the design of 'outs More

$227 USD in 4 days
(24 Reviews)

Hi, there! My name is Paris, and I was glad to see that you're looking for an Access developer. According to your brief, you want to have an Access database updated the way you describe in your brief. I opened the att More

$220 USD in 7 days
(160 Reviews)

Good Morning my name is Donna. I have read your project description and feel with detailed instruction we can achieve your needs. I have been an database developer for 19 years. I design, develop, test, implement and More

$177 USD in 2 days
(39 Reviews)

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on I am ready to carry out your project in the reasonable price and in the shortest possibl More

$150 USD in 3 days
(137 Reviews)

I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy r More

$30 USD in 1 day
(74 Reviews)

Hello I hope all's well with you. I viewed also your file [login to view URL] - looks nice. Please see the following screens in my portfolio : "Access Attendance", "Invoice & book-keeping management" and " Crea More

$500 USD in 4 days
(51 Reviews)

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

$200 USD in 2 days
(73 Reviews)

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. I propose to do the solution entirely in excel and excel vba. I can sh More

$155 USD in 3 days
(73 Reviews)

Hi, I'm an expert Access / VBA / database developer with 20 years of experience in database design and development and can do the job for you. Delivery within : 1 week Good quality work done, satisfaction guar More

$400 USD in 5 days
(40 Reviews)

I would like to know a little bit more about the project for an appropriate duration and cost as well. My name is Spanovic Borut and I'm Microsoft Certified SQL Server Database Developer&Administrator. I'm availab More

$30 USD in 1 day
(9 Reviews)

mphill in computer science having seven years of experience in database development especially in access, sql and MySQL.

$250 USD in 1 day
(14 Reviews)

I'm an experience MS Access and vba developer, have been in this field for almost 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access cert More

$111 USD in 5 days
(35 Reviews)

I am an MS Access and Excel Specialist and an experienced Freelancer who is dedicated to provide quality results within a reasonable timeline and budget. Accuracy is my priority so I believe I am the best freelancer fo More

$250 USD in 3 days
(48 Reviews)

Hi, I have a good experience in MS Access and Database Programming, etc... But I doesn't have lot of reviews in freelancer for these relevant skills. But I confirm you I can do this project very well. Also if you wa More

$90 USD in 2 days
(24 Reviews)

Hello, sir! I am happy to put my bid on your project. I have a full of experience with database management using Access macro. I have finished a lot of projects like this. I can show you one of them if you want. I More

$30 USD in 0 days
(10 Reviews)

Hello how are you? My name is Boris Schalk. I have read the job description you post. I have 10+ years strong experience with sql programming and MS Access/vba. So I'd like to contact you. Hope to meet you as soon. More

$111 USD in 5 days
(5 Reviews)

Hello. Below is my recent completed Access Project: Complex financial report in Access - Please also review my Portfolio to see my c More

$110 USD in 2 days
(5 Reviews)

Hi, I am interested. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.

$100 USD in 3 days
(5 Reviews)