Re: Reconciling Employee Forms and Database Records

From: Doug Bell (dug_at_bigpond)
Date: 05/19/04 

Date: Thu, 20 May 2004 09:09:11 +1000

Word is most likely on each PC but the problem with Word is that it is going
to be very difficult to maintain integrity and importing results will be
difficult.

Best solution would be an intranet web page that the users log onto, it
shows them the dheir data and allows them to update it.

You could also use Excel as the file format to send the data out and import
from. Excel is better than Word in that it has Cells so you can define what
Cell data you want to import. You can also lock the Work*** so that it is
protected from changes.

Maybe have some code to create a CSV file specific for each employee and
send it along with your User interface (Word or Excel) Then when they open
the document the form loads from the CSV file and when they update a field
it re-writes the csv file. They can send the CSV file back and it can then
be imported.

"Compu Geek" <anonymous@discussions.microsoft.com> wrote in message
news:6F770BC2-12B7-4745-9B83-68E0FF63657F@microsoft.com...
> I have an employee database. I want employees to fill in a form to
provided the data that the database stores. I need to email one form to
each user. In most cases, the employee records are partially completed
and/or out of date so the users will be updating fields in existing records.
When I export the data, it has to appear formatted i.e. with dropdown
controls and in some cases multiple fields may be listed in one column for
aesthetic purposes. When I receive the completed forms I need to import the
new data into the database from those forms. How can I accomplish this?
I'm guessing it involves Word mail merges but then how do I carry over form
controls?
>
> Note:
> In the input form I email out to people, there may be several fields in
one column, not one field per column as per regular Access data exports to
Excel and Word.
> This database is not web enabled and for various reasons I cannot web
enable it even if I wanted to.