Retrieve data from ACCESS file from WORD

[scriverb]

Please see thread: thread705-838980

I want to retrieve data from a table in an ACCESS database front-end file. This table has one record only and I want to retrieve a field that has a path string to word templates on a server. This path may change with the specific site.

So, through code in a MS Word 07 template I would like to read the access database and retrieve a fields value. Store it in a global variable and use it in macros through the template that is opened.

Table: tblDBParameters
Field: PathToEForms
Location: c:\access\lodwtbls


I am opening word through a shell statement and was attempting to pass this path string through the /cmd command line parameter when opening word. But, to no avail cannot seem to get the value passed.

Any ideas please.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[Dreamboat]

Is that really Word 7 or is it really Word 97?

Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books

 

[scriverb]

Oh, yes, it is WORD 97. Client is still using ACCESS 97 and Word 97.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[scriverb]

Pleae see thread: thread705-838980 RoyVidar and TonyJollans conspired to provide a solution to this problem.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]