PC Review


Reply
Thread Tools Rate Thread

An Access table linked to Word

 
 
Hal E
Guest
Posts: n/a
 
      12th Jan 2010
I have used a simalar concept since Access97. I build a table in Access and a
document in Word. I link The table to the word document using merge to fill
"fields" in the document.
On subsequent uses, the table is rebuilt programically. A button is pushed
to open the word document. They, the "Fields" are filled by clicking the
merge ("abc") button.
When the Word document is closed, program flow is returned to Access.
In 2000 and 2003 some minor changes were required. Why should 2007 be any
different?
Now, when the open Word document button is pushed, the word document opens.
The field identifiers are pressent. But, the merge("abc") button is ghosted
out? Why?
If I open the word document from the directory level, a dialog box ask me if
I want to open the link. Clicking yes opens the Word document showing the
field identifiers. But, now the merge("abc") botton is active. And, clicking
it fills the fields with all the proper data.

Any thoughts why it's not working from Access?

Using CreateObject("Word.Application") to go to Word from Access
 
Reply With Quote
 
 
 
 
Gina Whipp
Guest
Posts: n/a
 
      12th Jan 2010
Hal E,

You didn't mention, do you have Word 2003 or Word 2007? I ask because I
have seen this happen when you have Access 2007 and Word 2003.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Hal E" <Hal (E-Mail Removed)> wrote in message
news:600D7E5A-769F-465F-8E9B-(E-Mail Removed)...
>I have used a simalar concept since Access97. I build a table in Access and
>a
> document in Word. I link The table to the word document using merge to
> fill
> "fields" in the document.
> On subsequent uses, the table is rebuilt programically. A button is pushed
> to open the word document. They, the "Fields" are filled by clicking the
> merge ("abc") button.
> When the Word document is closed, program flow is returned to Access.
> In 2000 and 2003 some minor changes were required. Why should 2007 be any
> different?
> Now, when the open Word document button is pushed, the word document
> opens.
> The field identifiers are pressent. But, the merge("abc") button is
> ghosted
> out? Why?
> If I open the word document from the directory level, a dialog box ask me
> if
> I want to open the link. Clicking yes opens the Word document showing the
> field identifiers. But, now the merge("abc") botton is active. And,
> clicking
> it fills the fields with all the proper data.
>
> Any thoughts why it's not working from Access?
>
> Using CreateObject("Word.Application") to go to Word from Access



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ACCESS table linked to EXCEL spreadsheet. How to know which table is linked? Art Microsoft Access 3 2nd Apr 2007 12:51 PM
ACCESS table linked to EXCEL spreadsheet. How to know which table is linked? Art Microsoft Excel Discussion 3 1st Apr 2007 10:14 PM
extracting data from linked db2 table using access make table quer =?Utf-8?B?R2lueWN1YjIy?= Microsoft Access External Data 0 29th Aug 2006 07:31 PM
I cannot modify a linked table in access (linked to excel). =?Utf-8?B?RGViZGk=?= Microsoft Access External Data 3 30th Apr 2006 02:04 AM
UPDATE a linked access table with value from a ODBC linked SQL table JB Microsoft Access 0 18th Nov 2003 09:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:37 PM.