The project is to make a Makro bridge between MS Access and MS Word.
I have a premade MS Access database, that contains a query with ca 4 fields. The query will return between 1 and 10 records. What this query returns is determent by the MS Access database operater, and will not be included in this project. All that is already done.
The output of this query will be part of content is in a MS Word document that are also predemade. The only dynamic content of the Word document is 2 things:
1. The output of the query (1 to 10 names).
2. A logo (picture)
Now, both 1 and 2 is defined in the Ms Access database, before the makro (you are to make) is run.
Summary:
The makro is to do the following:
1. Make a new MS Word document based on a premade template, and insert the records from the query in to the right predifined place in the MS Word document. This document will contain lots of other static information (Template), so only the logo and the records from the query will be dynamic (edited in MS Access by user).
2. If there is a excisting document (That the makro has made before) i need be able to edit the record in MS Access, and all the MS Word documents that are affected by this change, will be updated. There might be some challenges here, but in some way there should be a decent soulution on this.
I will provide you with both MS Word document, and MS Access database complete with all fields and defenitions. You only need to make the bridge between the two applications, so the records will be inserted on the right place.
If you know VBA + MS Access + MS Word good, this should not be a weary big project.
I prefer MSN or Skype, so we save some time.
Good bidding :)
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Ms Access 2003 + MS Word 2003 + Windows XP + Maybe ODBC support (To be taled about)