Rerunning a script within Access

[Tina Brev]

Hello!

This may sound an over-kill but hoping it could be done via VB code.

I have fields in my tables that are being referenced into many of our Word documents. I need to find a script within Access that would open the file(s), refreshes, saves and closes. Would mean that for the future I would be able to keep the Word documents updated just by rerunning the script.

For example: I have fields in my tables called txtDescription, txtVendor, txtTool_ID. If for any reason a tool information has changed meaning Word documents affected by this change also needs to be updated.

I am trying to avoid linking the Word documents with the fields in my tables for I could be talking roughly 800 files.

Currently in our directory called J:/Eng/Lathe:
There are 16 subfolders and categorized by machine no., and each of these machine subfolders have at least 50 documents per folder. Not knowing exactly how many documents are affected if/when changes are made to 1 or more records.

I haven't tried any solution or approach for I have no clue where to start.

Your suggestion is very much appreciated!

 

[Fornatian]

Hi!!!
I assume you can't have these docs in the database as reports?

For my info

Do you have an index somewhere listing which records are linked to which doc's. That must be the first thing to collate before thinking about the coding.

Message to all: I don't know the answer to this one yet so please jump in with suggestions

Ian

 

[Tina Brev]

Hello Ian,

Thank you for your info. At least it's something.

I did ask the boss about somekind of listing and there is none.

Question for you though. I assume you can't have these docs in the database as reports? meaning?

Any good jokes for me lately?

[This message has been edited by Tina Brev (edited 02-04-2001).]

 

[Fornatian]

Not at the moment Trini, but rest assured that your problem will sit in back of my mind.

What I meant by:

I assume you can't have these docs in the database as reports?

Why have you got the documents in word in the first place - could you not simply recreate the documents in an access report/reports so that they look like word processor docs?
This would be especially beneficial if the 800 or so docs consists of 400 product information sheets or the like based on a template.

If you could recreate the document in an Access report you could have an easily accessible template sheet that you could alter to your hearts content and that would be instantly consistent with the field contents.

Maybe your docs are more complicated?

Ian

 

[Tina Brev]

Hello again Ian,

Unfortunately I have nothing to do with the documents being in Word. I just started working for the company 6 mths ago and they have this system set-up for years.

However, I have in process recreated the document using a form(template) instead of a report because there are fields in the document that require data entry from the user where report will not give me that capability (unless you tell me otherwise).

Do keep me in mind when you come up with more ideas. You know how to get hold of me.
And thank very much for all your feedback.

Trini

 

[Fornatian]

Cognitive Hourglass On...
(Hmmm.Do you think maybe I've been using windows a bit too long?)

 

[Tina Brev]

Cognitive Hourglass On...??????

Speak Up!!! in English please!!

 

[Fornatian]

Still thinking...