View Single Post
  #8  
Old January 12th, 2005, 03:53 AM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

Now, this seems like a question for a Word NG. Can you export the data to a
text file and then use the text file as the data source?

--
Duane Hookom
MS Access MVP


"Taika Bilbo" wrote in message
...
I am updating the Word feild by right-clicking on the field and selecting
"Update Feild".
Below is an example feild I am currently using in MS WORD to extract data:

{DATABASE \d "C:\\FILEPATH\\My_Access_Database.mdb" \c "Table My Data
Table"
\s "SELECT [Data X] FROM [My Data Table] WHERE (([Data Section Heading] =
'My
Data')) ORDER BY [Data Number]" \l "20' \b "55" \h \* MERGEFORMAT}

Now, in MS WORD, this would be highlighted in gray due to it being a Word
field. To update the field, I would right-click and select "update field",
here is when some built-in, automatic office code goes to work, and grab
to
stuff out of Access.

Now, with Access 2000, the instance of the Access program opens, and stays
open each time I update the field.


"Duane Hookom" wrote:

This might be clear to someone else but not me. I still have no idea how
you
are doing your update from Word. Are you opening an ADO recordset from
Word
and then find specific records in Access to update bookmarks in Word?

--
Duane Hookom
MS Access MVP


"Taika Bilbo" wrote in message
...
Hi,
I have a requirements database in Access, that contains tables of, for
example, constants. In MS Word, I created a feild, that goes into the
DB,
and
grabs the constants per some requirements, and puts them in tabel form
in
Word.

The problem is the way Access, as a whole, acts. Say I update a bunch
of
data in my constants table in the DB. I now have to open the applicable
Word
Documents, and update the field that querys the constants table in MS
Access.
When the DB was in Access 97, I could not have Access open, and when I
updated the word field, Access would open, update the Word feild and
close
automatically (through no programming, or setting settings). I had to
convert
this database to Access 2000. Now when I update a field, Access opens
and
stays open after doing the update. Not only does an instance of my DB
open,
but it also opens my "top level" form. So in essence, each time I
update a
Word feild, I get two db instances on my taskbar. After working for 1
hour, I
have 50 things to close. It gets annoying.

I have looked in options, settings, and the internet for a solution,
and
cannot find anything.

Did I make the problem clear?

Thanks so much.

"Duane Hookom" wrote:

You might need to describe what you are doing. Are you referring to a
Word
Merge Field? Are you running any code in Word (or Access) that you
would
care to share with us?

--
Duane Hookom
MS Access MVP


"Taika Bilbo" wrote in message
...
Hi,
There is no other way to manually update a MS WORD field. This also
occurs
with some automatic SQL code that is hooked to Access 2000. Due to
it
not
occurring in Access 97, and not 2000, there is hopefully a fix for
it,
or
a
way to curb it.

Has anyone come across this, and resolved it?

"Duane Hookom" wrote:

You might need to change the method you are using.

--
Duane Hookom
MS Access MVP


"Taika Bilbo" Taika wrote in
message
...
When I update a feild in MS Word, Access opens up to get the
proper
information, but does not close when it is finished. Essentially,
every
time
I update a feild, I get 2 instances of Access 2000. This did not
happen
with
Access 97. Is there a way to stop this from happening?