Create a make table for one record

  • Thread starter Thread starter Phil Lefter
  • Start date Start date
P

Phil Lefter

I have a database which keeps track of jobs to be worked. I also have a Word
document that is several pages long which contains some information I have
in the database.
I would like to automate the data transfer between Access and Word using the
mail merge process. Because I am only printing these documents for each new
job input I need to be able to make a table for one record.
My thoughts are to have a command button on the form which triggers a macro
that refreshes the form, starts a make table query which includes only that
one record.
From there I can open the word document already set up to mail merge to a
predetermined data source (the made table), which will update itself from
the newly updated record in the table. From there I can print the document
and live happily ever after.
My barrier is figuring out how to get the data from my input form into a
make table. The rest I know how to do. Any help is welcome... Phil
 
I would like to automate the data transfer between Access and Word using the
mail merge process. Because I am only printing these documents for each new
job input I need to be able to make a table for one record.
Click to expand...

You're assuming that you must create a Table to do a mail merge. This
assumption is INCORRECT.

Just do the mail merge using the one-record Query returning the data
that you want.
 
Thanks for the clarification, BUT how do write a query that will show the
current record in my form and then update it the next time I want to print
the document. I read about filters but I want to automate the process to
nothing more than a button click if possible. Thanks for your response...
 
Thanks for the clarification, BUT how do write a query that will show the
current record in my form and then update it the next time I want to print
the document. I read about filters but I want to automate the process to
nothing more than a button click if possible. Thanks for your response...
Click to expand...

Since I have no trace of a clue how your tables or your form are
structured, I can only give a broad hint. Assuming you have a unique
field (a Primary Key) named ID in your table, and that there is a
control named txtID on the form named frmMyForm, you can create a
query based on your table using a criterion on ID of

=[Forms]![frmMyForm]![txtID]

Save this Query and base your WORD MailMerge on it (rather than on
your table). No button click is needed, unless you want to open Word
from Access.
 
Your criterion worked great, I was putting the phrase in the wrong place in
the query.
You mentioned being able to open Word from Access. Are you saying I can open
a specific Word document, like my mail merge document using a command
button? Can you point me in the right direction in Help to learn how to do
that?
In my opinion, when it gets to the actual "how to" the help section of
Access gets a little cryptic. particularly on subjects like macros,
functions and VBA. Again any help is welcome. Phil
 
Back
Top