Sedang Disiapkan

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]

Kemahiran: Excel, Microsoft Access, Visual Basic untuk Aplikasi, Word

Lihat lebih lanjut: 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

Tentang Majikan:
( 173 ulasan ) Mississauga, Canada

ID Projek: #4050727

Dianugerahkan kepada:

seharsuleman

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

$50 USD dalam 3 hari
(1 Ulasan)
1.4

17 pekerja bebas membida secara purata $92 untuk pekerjaan ini

fastudiovw

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

$95 USD dalam 3 hari
(629 Ulasan)
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 dalam 5 hari
(56 Ulasan)
6.0
Krusche

As discussed previously.

$180 USD dalam 4 hari
(26 Ulasan)
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 Lagi

$125 USD dalam 3 hari
(6 Ulasan)
5.4
rengrish

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

$70 USD dalam 2 hari
(52 Ulasan)
4.7
www1980

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

$30 USD dalam sehari
(10 Ulasan)
3.9
cosconeaionut

Contact me when you want to start :)

$90 USD dalam 2 hari
(8 Ulasan)
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 Lagi

$75 USD dalam 7 hari
(2 Ulasan)
3.3
shaarawi

I can help

$100 USD dalam 3 hari
(8 Ulasan)
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 dalam 5 hari
(0 Ulasan)
0.0
rkkamlesh007

May I help you ?

$125 USD dalam 7 hari
(0 Ulasan)
0.0
teovo

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

$50 USD dalam sehari
(0 Ulasan)
0.0
MSDev2012

Dear sir , I can create your project thanks

$30 USD dalam 2 hari
(0 Ulasan)
0.0
nector999

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

$55 USD dalam 5 hari
(0 Ulasan)
0.0
onlyLekha

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

$72 USD dalam sehari
(0 Ulasan)
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 dalam 3 hari
(0 Ulasan)
0.0
ExpertoAccess

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

$150 USD dalam 2 hari
(0 Ulasan)
0.0