C
css
I'm trying to modify Albert Kallal's Super Easy Word Merge database.
I'm not looking to do a mail merge, but to merge a different table with word.
Here's the ideal setup:
A manager will create a word document based on a template and enter steps to
be completed when a piece of equipment is returned from rental. Then the
manager will be able to enter in Access the unit number and reference the
document name to be printed.
When a piece of equipment is returned, an employee will enter the unit
number, Access will open the appropriate document in Word, merge in a unit
number and description, print it, then close.
The reason for the Word document is for the manager to be able to set up the
returned service as he sees fit. I wanted to avoid having a separate document
for each unit. For example, all generators would open the same document, just
the unit number and description would vary. But, if we stocked a generator
that required a something different, we'd have the ability to create a
separate document to allow for the change.
I can create a table with unit number and document name. Then I'll run a
query in vb for the employee to enter the unit number. VB will pull the unit
number & appropriate document to a temp table ("TempMerge"), then merge &
print the word document.
I don't know how to modify Albert Kallal's database to allow me to create a
document that'll pull anything but the defaulted Contacts table.
I've tried to directly open the word merge, but am having issues with 'Error
5922: Word was unable to open data source.'
That's why I tried Kallal's db.
I'm just getting really frustrated now & not sure what way to turn.
Any help would be appreciated.
Connie
I'm not looking to do a mail merge, but to merge a different table with word.
Here's the ideal setup:
A manager will create a word document based on a template and enter steps to
be completed when a piece of equipment is returned from rental. Then the
manager will be able to enter in Access the unit number and reference the
document name to be printed.
When a piece of equipment is returned, an employee will enter the unit
number, Access will open the appropriate document in Word, merge in a unit
number and description, print it, then close.
The reason for the Word document is for the manager to be able to set up the
returned service as he sees fit. I wanted to avoid having a separate document
for each unit. For example, all generators would open the same document, just
the unit number and description would vary. But, if we stocked a generator
that required a something different, we'd have the ability to create a
separate document to allow for the change.
I can create a table with unit number and document name. Then I'll run a
query in vb for the employee to enter the unit number. VB will pull the unit
number & appropriate document to a temp table ("TempMerge"), then merge &
print the word document.
I don't know how to modify Albert Kallal's database to allow me to create a
document that'll pull anything but the defaulted Contacts table.
I've tried to directly open the word merge, but am having issues with 'Error
5922: Word was unable to open data source.'
That's why I tried Kallal's db.
I'm just getting really frustrated now & not sure what way to turn.
Any help would be appreciated.
Connie