Afternoon all,
I'm wondering if anyone can help with the following problem, or can share their experiences of finding a workable solution with a similar objective.
I have an access front end application which runs from a SQL Server back end database.
Part of the daily work for users is preparing papers for panels and medical tribunals.
These panel papers include the case summary and a list of the included documents which are being tendered from evidence. Currently this is achieved by users selecting the items that they wish to list on Case Summary or front cover, the report is then generated with this information. The problem here is that an assistant is then required to go through the summary, load the files and manually build and paginate a document which includes the case summary and the evidence(files).
Ideally I am looking to implement a solution where the choices that are sent to the report display the case summary and the index in the report header, with the files which are the supporting evidence being opened, numbered and displayed through the report detail.
File location: The database holds the file location in a string, and the file type extension.
File types: The types of files vary from word documents, scanned images, and pdf's.
What is the best way for doing this, is it even possible? Can anyone direct me on the right path for what I would need to research to provide a workable solution.
Thanks in advance
I'm wondering if anyone can help with the following problem, or can share their experiences of finding a workable solution with a similar objective.
I have an access front end application which runs from a SQL Server back end database.
Part of the daily work for users is preparing papers for panels and medical tribunals.
These panel papers include the case summary and a list of the included documents which are being tendered from evidence. Currently this is achieved by users selecting the items that they wish to list on Case Summary or front cover, the report is then generated with this information. The problem here is that an assistant is then required to go through the summary, load the files and manually build and paginate a document which includes the case summary and the evidence(files).
Ideally I am looking to implement a solution where the choices that are sent to the report display the case summary and the index in the report header, with the files which are the supporting evidence being opened, numbered and displayed through the report detail.
File location: The database holds the file location in a string, and the file type extension.
File types: The types of files vary from word documents, scanned images, and pdf's.
What is the best way for doing this, is it even possible? Can anyone direct me on the right path for what I would need to research to provide a workable solution.
Thanks in advance
