Some Access DB edits to merge with a word document

In Progress

If you know Access, Excel, Word 2007 and vba, this one will be easy for you!

just need you to create a db with a form for entering based on this excel file I have. I'll be able to select a person and all the items for that person will show up in the form to enter.

Then when a button is hit, it will save that form's data to another table with a unique id and also merge that information to a word document.

I ALREADY HAVE THE MERGE CODE FOR THE WORD DOCUMENT and the WORD DOCUMENT IS ALREADY MADE.

All you have to do is design the database and fit the merge code in.

I estimate around 5 hours of work. Thanks

Thanks!

Here are detailed notes:

Start with the basics

Then to merge

0. put in all the fields from the tables in the forms.

1. inv form

Choose client dropdown:

a)

-dropdown linked to client table

-displays nameuse

b)

-fills in monthrecur subform

-fills in currentexpenses subform

-fills in client history subform

- fills in special message

- fills in for

2. Monthrecur subform (editible)

- item(s) that gets added everymonth

- if an inv has been generated with it in it, that monthrecur month gets set to YES (default no)

3. Currentexpensestemp (editible)

- just a temp table

- I can enter in values and it will store it there until the inv button is pushed

4. Client inv history subform (not editible)

-client history shows every inv with month recur items, client name, inv num , currentexpenses items on one line that was created

5. Create inv button

- creates the inv in inv table

- only includes the monthrecur if check mark (include recur) is checked

- if it includes the monthrecur, set the latest monthrecur month that is a "no" to "yes" (that will be the month indicated on the merged document and in the inv table)

- includes every item in currentexpensestemp, currentexpensetemp table goes blank for that client, while those values get stored in currentexpenses table)

- merges with word document

-fills inv field: sent with the current date

-

6. merge with word document procedure (attached word document)

- merges with word document based on invID

- creates word document in a special directory with the filename: [url removed, login to view]

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

See more: message to client, excel vba db, excel form to enter data, design merge, design access database, access db forms, vba for word, microsoft word on line, microsoft vba, microsoft excel vba, excel mark, access subform, yy, word merge, vba word, vba access excel, microsoft access vba, merge data, excel word, excel vba form & data work, data merge, client form excel, word merge excel, select month form excel vba, word merged

Project ID: #4050727

Awarded to:

seharsuleman

i have a good experience of working with Access. Have developed 2 complete applications in MS Access

$50 USD in 3 days
(1 Review)
1.4

17 freelancers are bidding on average $92 for this job

fastudiovw

I have 20+ years of experience programming ms-access & sql server. At your disposal for any doubt or question, Regards Fabio

$95 USD in 3 days
(629 Reviews)
7.2
uumairkhalid

Hi.. Expert database developer here. Assure you accurate database according to your requirements. My bid is for exact database. Ready to start. Have a look at PM. Regards

$100 USD in 5 days
(56 Reviews)
6.0
Krusche

As discussed previously.

$180 USD in 4 days
(26 Reviews)
5.6
tootwotrue

Hello, After reviewing your project posting, I believe that I am well suited to fulfill the project's requirements and am thus submitting my credentials for your consideration. My development history in a nutsh More

$125 USD in 3 days
(6 Reviews)
5.4
rengrish

Hi I am interested in this project. Ready to take up immediately.

$70 USD in 2 days
(52 Reviews)
4.7
www1980

Ready for this project. Long experience in developing DB in Access. Newbie to freelancer.

$30 USD in 1 day
(10 Reviews)
3.9
cosconeaionut

Contact me when you want to start :)

$90 USD in 2 days
(8 Reviews)
3.6
MichaelSDeVries

Dear ansales, I can help you quickly and cost effectively design and develop a Microsoft Access database/system that satisfies all of your requirements for your Microsoft Access database/system. I have been desig More

$75 USD in 7 days
(2 Reviews)
3.3
shaarawi

I can help

$100 USD in 3 days
(8 Reviews)
2.6
braecons

Hi I am an advanced Access developer who works for both small and large organisations. I can do this task quickly and accurately should you so desire.

$150 USD in 5 days
(0 Reviews)
0.0
MSDev2012

Dear sir , I can create your project thanks

$30 USD in 2 days
(0 Reviews)
0.0
rkkamlesh007

May I help you ?

$125 USD in 7 days
(0 Reviews)
0.0
ExpertoAccess

Am Chilean Programer, and i think's is very easy make you DB. hope you contact.

$150 USD in 2 days
(0 Reviews)
0.0
CorneliusAveling

I don't have a degree or anything fort his, but I have done it before, and I can give ti a go for you.

$50 USD in 3 days
(0 Reviews)
0.0
onlyLekha

Yes sir I can do this task in only one day. Just provide related documents.

$72 USD in 1 day
(0 Reviews)
0.0
teovo

I have 4 years experience in Excel VBA development. I can finish your app soon with high quality.

$50 USD in 1 day
(0 Reviews)
0.0
nector999

I am working in Microsoft Access from 6 years as database administrator.

$55 USD in 5 days
(0 Reviews)
0.0