[AccessD] Setting data into and getting data from Named Range s

Jim,

I did, and thanks for the offer.  I think that understanding that it is the
range object that actually does the work kind of removed my mental
roadblocks.  I was thinking that the name object should have abilities that
it doesn't have.  I sent an email re "success" to the group.  

Again, thanks for the offer.  If I run into any more roadblocks I will keep
you in mind.  Kind of the last piece for right now is reading data back out
of a named range.  I have code for doing that, though it is kind of rough
ATM.

This is for a client who is documenting construction of a hospital.
Apparently federal law requires that they collect documents for each and
every one of certain kinds of systems, paper and electronic, and store them.
My client did not understand the size of the job when he got involved, nor
when he got me involved.  

I am of course building a database to track all of the documents, request
them (electronically) from each contractor (via this Request For Document
spreadsheet, attached to emails) for each document, then as the electronic
documents are returned via attachments to the email I send, strip the
attachments off and file them in an intricate directory structure out on the
hard disk.  There will be literally thousands of documents, perhaps tens of
thousands.  6 contractors, 91 systems (though some are "copies", i.e. 7 "Air
handling units"), and ~150 documents, although all docs are not required for
all systems.  My db has to track what has been requested, store "proof" that
we did request them (each Excel RFD is saved in the same directory
structure), track which docs are received back, report which docs are "owed"
by which contractors for which systems, and report which system's documents
have been completely received.

We are trying to convince all the contractors to work with us in naming the
documents to a standard so that as the attachments come in I can parse the
doc name to see what system/document it is and "count it as received".
There are just so many documents that to do this stuff manually would invite
chaos.

On top of all that, the requirement is for both paper copies as well as
electronic copies, so the db has to track both.  My client has to make paper
copies from Electronics where no paper exists, and make electronic from
paper where no electronic exist, and get it all entered in the db each time.

And finally, the main company (Pfizer) in charge of construction, had the
unfortunate experience of having their paper copies burned to the ground one
time.  As a result I also have to ensure that the electronic copies get
automatically written to a local and offsite location, which I will be doing
via high speed internet.  I have to track that each electronic document gets
written to the back up location as well - a usb hard disk on a computer
somewhere out on the internet.  Since the internet can be unavailable, I
have to handle that as well, performing the write when the internet becomes
available.

The paper in this case will completely fill a single wide trailer when all
is said and done, and in fact they have a single wide trailer that they are
using to collect the paper.  When they are done they will hook up a truck
and haul the paper... Somewhere... Hopefully fireproof.  ;-)

This is where "time and expenses" really takes on meaning!  I quoted 40
hours to do what my client originally asked for - and DELIVERED that.  Of
course my client did not understand the scope and so we soldier on.

John W. Colby
www.ColbyConsulting.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Monday, January 23, 2006 1:45 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Setting data into and getting data from Named Range s

John,
I sent you an email, did you get it?
Jim Hale