Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / March 2007

Tip: Looking for answers? Try searching our database.

Exporting/Importing same Form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
duet76 - 16 Mar 2007 16:59 GMT
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) - 18 Mar 2007 03:25 GMT
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;
Signature


       Ken Snell
<MS ACCESS MVP>

> Here is what I am supposed to accomplish:
>
[quoted text clipped - 24 lines]
>
> Juliet
duet76 - 28 Mar 2007 15:38 GMT
On Mar 17, 9:25 pm, "Ken Snell \(MVP\)"
<kthsneisll...@ncoomcastt.renaetl> wrote:
> 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
[quoted text clipped - 43 lines]
>
> - 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) - 29 Mar 2007 01:38 GMT
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..!
Signature


       Ken Snell
<MS ACCESS MVP>

> On Mar 17, 9:25 pm, "Ken Snell \(MVP\)"
> <kthsneisll...@ncoomcastt.renaetl> wrote:
[quoted text clipped - 66 lines]
>
> Juliet
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.