Near Phila, PA, USA: make $ doing Access programming.
I know somebody who might pay $3000 to $5000 American for an Access application. Since it is probably necessary to talk directly to the person with the problem, it seems to me that only somebody near Philadelphia, PA, USA can do this job. I do not know a lot about this application, so I cannot make up specifications for you. You would probably have to work without detailed functional specifications, but would be shown documents currently being created via WordPerfect or MS Word. Studying the documents and how they are currently being created should give a good idea of what is required.
Several months ago, I created some WordPerfect macros which would insert name, address, and other data into WordPerfect documents. The task required has gotten more complex. It looks to me like an Access DataBase application is required, with some of the fields being OLE Links to MS Word documents.
Not sure if this is the correct place to look for a guru to do this job. This is what the application should be able to do.
Maintain a data base Table with a few (3-7) MS Word Document Templates. Maintain a separate Table with many MS Word Documents, each derived by inserting data into one of the Templates. It seem to me that Access Table Fields should have OLE Links to the MS Documents, rather than embedded documents. This would allow MS Word to be used to update and/or print the Templates and the documents, with the person doing the updating knowing MS Word but not much else.
The Word Documents to be created are contracts and/or descriptions of some type of investment or annuity or trust agreement.
User expects to be able to enter Name, Address, Telephone number on some user friendly data entry screen, after which the software queries him for additional information and decides which of several types of document is required. I do not think the decisions to be made here are complex.
Then the user-entered data is inserted into pertinent places in the template selected, creating a Word Document. A new entry in the second Table is created. This Table has some name, address, et cetera data, and an OLE Link to the MS Word Document created.
The user would create the Templates using MS Word. The user would also do some updating of the Templates and MS Word Documents created. The printing of the MS Word Documents would probably be done using MS Word rather than the Access application. The Access Application might be required to generate some reports and/or be able to answer some simple queries about the documents.
The reports and/or queries would relate to user entered data which was inserted when documents were created from the templates. Example: I am guessing that user would like to know the address, telephone number, or File-Name Path associated with a document. This data could be obtained using the name (of a person) embedded in the document, assuming that the name was put into an index field in the Database Table.
If somebody here could make a deal with the potential user of this application, I would like to get a modest finder’s fee (5-10%). I would take my chances on a gentleman’s agreement.
I am easy to get along with, but the potential user might be difficult. He runs a small business. I am not sure that he would be difficult to deal with, but he might be.
