Where do you guys store Word docs?

magster06

Registered User.
Local time
Today, 07:20
Joined
Sep 22, 2012
Messages
235
Hello all,

I have a few auto populated forms (Word docx) and was wondering where you guys store your forms?

Do you just keep them in the documents folder on your computer or do you store them in a table within Access?

Thanks!
 
I always store Word documents externally. The easiest method I've found is to store the file in the same folder as the back-end database file. Then check for the location of one of the back-end tables to get the fully qualified name of that BE file. Then se InStrRev to parse out the beginning of the name field. Anything to the left of that is device and path info, which I then use to identify the location of the Word file.

I don't use Word for forms. I use Word for a help file that I created as a sort of "roll your own" sort of specialized help using a command button and some VBA code on my forms.
 
Thanks for the reply The_Doc_Man!

I am new to Access and did not know what the general practice was concerning the storing of Word forms.
 
The general practice is to never store anything bulky in your database "imbedded" because of that pesky 2 Gb limit. The ONLY thing I store imbedded in my database that isn't a table, query, form, report, macro, module, or relationship is one small image that is a department logo. Everything else is either a hyperlink or I compute the path as being relative to my back-end file.
 
Magster06 I am curious how you are auto populating those forms? I have a reservation system that requires me to create contracts where I am simply updating dates, addresses and contact name. I have been trying to figure out for the longest time how to autopopulate them an haven't been able to. Any advice?
 

Users who are viewing this thread

Back
Top Bottom