In Progress

Some MS Access edits to merge with Word Document

Hi, if you are good with MS Access , word and know how to do a bit of VBA, then this one is easy for you!

I've created a very simple database , but some of the backend functionality I cannot do, here's what I need:

So with this database, all data entry is on the client form. (don't worry about the little buttons)

There are only 2 functions that you need to code in:

1. Create Invoice (on the client form) and 2. Create word document (on the invoice form)

1. Create Invoice

a) Creates a new invoice

b) COPIES monthrecur and currentexpenses to invmonthrecur and invcurrentexpenses (nothing is deleted)

c) Add 13% to the total of invmonthrecur to invmonthrecur as "HST" in the description

d) Fills in clientID and name use on the invoice form

e) Generates an invoice number (takes the currentinvnumber from invnumbertemp table then adds a random number from 100 to 300 to it)

f) invoice date = now()

2. Commit

a) Saves the "currentinvnumber" in the invnumbertemp table and saves it as lastinvnumber. Then saves teh invoicenumber from the form as the currentinvnumber in the invnumbertemp.

3. Word merge

a) It's already 97% complete - I supply you with the word merge document and the word merge code and you put it in

If you are selected, I will send you the database, the word merge will be later on.

That's it! Probably no more than 2-3 hours of work.

Thanks

Skills: Microsoft Access, Visual Basic, Visual Basic for Apps, Word

See more: access word merge, send word now, ms access work, ms access form data entry, ms access data entry form, microsoft access data entry form, how to send an invoice, how to create a data entry form in access, how to create a data entry form, data entry ms access, data entry in ms access , create data entry form access, create an access form for data entry, access database data entry form, what is ms access, what is microsoft word, vba for word, microsoft vba, word merge, vba word, vba e, ms access vba, ms access 2013, microsoft access vba, merge data

About the Employer:
( 173 reviews ) Mississauga, Canada

Project ID: #4187107

Awarded to:

isupportu

Hi I can do this. Please Check PM.

$35 USD in 0 days
(7 Reviews)
3.2

6 freelancers are bidding on average $93 for this job

amcsummers

I have been doing my contracting work with VWorker/Freelancer for the past 3 years, I had completed 70 projects ranging from Excel VBA to SQL Server database constructions. I am in the Phoenix, AZ area so we are in More

$75 USD in 1 day
(54 Reviews)
5.4
MattThrower

I have over 9 years of MS Access experience.

$100 USD in 2 days
(11 Reviews)
4.8
salih0vicx

Hello cold Canada :-) I am looking forward to working with you... Regards from cold Bosnia :-(

$99 USD in 3 days
(6 Reviews)
4.2
srdas2012

Helo Sir, We are Expert in VB,Access ,We can do your Job in VB6.0 all the outputs as desired by you,Please see PM

$50 USD in 7 days
(12 Reviews)
4.2
DaddyWarbucksEsq

My name is George Panko, dba The Immaculate Cohhection. I am relatively new to this freelancer site, but am well-established on Guru.com. Since 2001, I have specialized in designing, developing, and maintaining MS More

$200 USD in 5 days
(0 Reviews)
0.0