Exporting/Importing same Form

[duet76]

Here is what I am supposed to accomplish:

I have a Corrective Action Database. We e-mail out the Corrective
Actions (A Report) to individuals to fill out in word, through the e-
mail function in Access.

I now need to e-mail out a word form from the database that is to be
filled out, returned and imported back into the database. This data
must be imported into the same record it came from. Primary Key to
Primary Key.

I have the form built per the following instructions:

http://msdn2.microsoft.com/en-us/library/aa155434(office.10).aspx

How do you do this?

Currently, the instructions above have the form importing into a
seperate table. Could I do an Update Query? How do I export the
Primary Key and match it back when I import it back in?

I am obviously not an advanced vba user. I wouldn't say I am a
beginer either. If someone could throw me a bone to get started I
would appreciate it.

TIA,

Juliet

 

[Ken Snell \(MVP\)]

Importing the data to a "temporary" table is best way to get the data into
the database. From there, one usually would run an update query that changes
the data in the permanent table to what is in the temporary table.

A generic update query statement might be something like this:

UPDATE PermanentTableName AS PermT
INNER JOIN TemporaryTableName AS TempT
ON PermT.PrimaryKey = TempT.PrimaryKey
SET PermT.FieldName1 = TempT.FieldName1,
PermT.FieldName2 = TempT.FieldName2,
PermT.FieldName3 = TempT.FieldName3;

 

[duet76]

Importing the data to a "temporary" table is best way to get the data into
the database. From there, one usually would run an update query that changes
the data in the permanent table to what is in the temporary table.

A generic update query statement might be something like this:

UPDATE PermanentTableName AS PermT
INNER JOIN TemporaryTableName AS TempT
ON PermT.PrimaryKey = TempT.PrimaryKey
SET PermT.FieldName1 = TempT.FieldName1,
PermT.FieldName2 = TempT.FieldName2,
PermT.FieldName3 = TempT.FieldName3;
--

Ken Snell
<MS ACCESS MVP>











- Show quoted text -

Hello,

I didn't specify all I have to do. My bad. I have a two part process
to accomplish. I am working on Ken's answer to part 2 of the process.

I have to export header information into the Word form with
information from the database. Then the user fills out the rest of
the information in the fields of the Word form. Then I re-import this
into the database.

Is it possible to "print or e-mail" a Word form with exported data on
it, then re-import the form fields back into the temporary table?

I am so lost.

TIA,

Juliet

 

[Ken Snell \(MVP\)]

I have not worked with Word the way you are trying to, so I cannot provide
suggestions for you about how to export/email a Word file specifically.
Perhaps another reader has some info that will assist you with this
approach. Sorry..!