C
celticangyl
I have two Access DBA's and Three heavily customized Word Template's
which save in categorized sub-directories.
Tow Warnings - Access DB
Reports - Access DB
Daily Reports - Word Template
Incident Reports - Word Template
Supplemental Reports - Word Template
At this time I use START - FIND from the windows menu to search for
text containing and then have to open each individual file and then
search once that file is open. What I'm trying to do is add to
[Reports]! a search, set of queries and report which would allow a user
to type in the information he's looking for, say a license plate number
and it would pull all references of this into the single report.
My approach so far has me pulling query from Tow Warnings but I haven't
come up with an efficient way to pull the data from Word documents. At
this time I'm writing some VBA in the Word templates that adds a
Before_Close event saving the data contained in these documents to yet
another Access DB that would remain in the background scheme for the
average user for ease of my sanity.
My experiance in Access VBA is somewhat limited but transitioning from
Word VBA shouldn't be difficult. Any suggestions or ideas would be
greatly appreciated as right now I seem to be doing more thinking than
coding on this problem.
Thanks,
Brian
"It is not wise to meddle in the affairs of dragons, for you are
crunchy and taste good with ketchup"
which save in categorized sub-directories.
Tow Warnings - Access DB
Reports - Access DB
Daily Reports - Word Template
Incident Reports - Word Template
Supplemental Reports - Word Template
At this time I use START - FIND from the windows menu to search for
text containing and then have to open each individual file and then
search once that file is open. What I'm trying to do is add to
[Reports]! a search, set of queries and report which would allow a user
to type in the information he's looking for, say a license plate number
and it would pull all references of this into the single report.
My approach so far has me pulling query from Tow Warnings but I haven't
come up with an efficient way to pull the data from Word documents. At
this time I'm writing some VBA in the Word templates that adds a
Before_Close event saving the data contained in these documents to yet
another Access DB that would remain in the background scheme for the
average user for ease of my sanity.
My experiance in Access VBA is somewhat limited but transitioning from
Word VBA shouldn't be difficult. Any suggestions or ideas would be
greatly appreciated as right now I seem to be doing more thinking than
coding on this problem.
Thanks,
Brian
"It is not wise to meddle in the affairs of dragons, for you are
crunchy and taste good with ketchup"