I gang

Some Access DB edits to merge with a word document

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]

Færdigheder: Excel, Microsoft Access, Visual Basic for Apps, Word

Se mere: message client, excel form enter data, design merge, design access database, microsoft word line, microsoft vba, microsoft excel vba, excel mark, access subform, yy, word merge, vba word, vba access excel, microsoft access vba, merge data, data merge, client form excel, word merge excel, word merged, excel access table, create file table access, data merge word, excel vba merge tables, word table excel vba, excel vba word

Om arbejdsgiveren:
( 173 bedømmelser ) Mississauga, Canada

Projekt-ID: #4050727

Tildelt til:

seharsuleman

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

$50 USD in 3 dage
(1 bedømmelse)
1.4

17 freelancere byder i gennemsnit $92 for dette 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 dage
(629 bedømmelser)
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 dage
(56 bedømmelser)
6.0
Krusche

As discussed previously.

$180 USD in 4 dage
(26 bedømmelser)
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 Mere

$125 USD in 3 dage
(6 bedømmelser)
5.4
rengrish

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

$70 USD in 2 dage
(52 bedømmelser)
4.7
www1980

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

$30 USD på 1 dag
(10 bedømmelser)
3.9
cosconeaionut

Contact me when you want to start :)

$90 USD in 2 dage
(8 bedømmelser)
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 Mere

$75 USD in 7 dage
(2 bedømmelser)
3.3
shaarawi

I can help

$100 USD in 3 dage
(8 bedømmelser)
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 dage
(0 bedømmelser)
0.0
rkkamlesh007

May I help you ?

$125 USD in 7 dage
(0 bedømmelser)
0.0
teovo

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

$50 USD på 1 dag
(0 bedømmelser)
0.0
MSDev2012

Dear sir , I can create your project thanks

$30 USD in 2 dage
(0 bedømmelser)
0.0
nector999

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

$55 USD in 5 dage
(0 bedømmelser)
0.0
onlyLekha

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

$72 USD på 1 dag
(0 bedømmelser)
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 dage
(0 bedømmelser)
0.0
ExpertoAccess

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

$150 USD in 2 dage
(0 bedømmelser)
0.0