Jeff-
Thanks for the contribution!
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jun 8, 2015, at 8:13 PM, Jeff jpjones23@earthlink.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
FWIW, not too long ago I built an Access database for an agency in my state. In addition to building email messages, it had an alternative to build Word documents or letters. As I build something, one of my ongoing objectives is to provide my client with a tool that they can maintain without a developer's intervention after I declare victory and escape.
With this database, a message or letter could be sent individually to multiple people. The messages or letters, potentially 100's, were saved for audit purposes however, each needed to be easily accessible to the users so I built a form that displayed those who had received communication(s). by name. along with the ability to open and display any message(s) or letter(s) that had been sent to them.
I shared all this to set context to now share the fact that I had a single record table in the database that retained the path for the saved communications. This allowed me to do a single call to get the path so that when the servers or disk assignments change, and they always do, the users could update that single record via a Utility Form and all files to be saved or read would continue to be found after being moved without the need for code changes.
This approach might be useful to someone is they have similar requirements and haven't thought of it themselves.
Jeff
With this database, a message or letter could be sent individually to multiple people. The messages or letters, potentially 100's, were saved for audit purposes however, each needed to be easily accessible to the users so I built a form that displayed those who had received communication(s). by name. along with the ability to open and display any message(s) or letter(s) that had been sent to them.
I shared all this to set context to now share the fact that I had a single record table in the database that retained the path for the saved communications. This allowed me to do a single call to get the path so that when the servers or disk assignments change, and they always do, the users could update that single record via a Utility Form and all files to be saved or read would continue to be found after being moved without the need for code changes.
This approach might be useful to someone is they have similar requirements and haven't thought of it themselves.
Jeff
-----Original Message-----
From: "John Viescas JohnV@msn.com [MS_Access_Professionals]"
Sent: Jun 8, 2015 1:42 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Code not saving to the correct folder
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (12) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar