Replies

I was afraid you were going to say that… I’m a complete novice when it comes to VBA, but I’ll search around and see if I can find some suitable code to build on. Thanks.

Yes, and nothing seems to work. Besides, I need to keep it easy for the people who will be using the form. Digging into the advanced find field isn’t going to fly.

BTW, I’m trying to do this in a public folder (so everyone can share the same contact list).

I’ll give it a shot. Thanks!

That did the trick. I need to create the new approval doc, and roll everything into production. My next project is to replace the error messages that pops up when they try to print an approval letter for an account that isn’t approved with something that is a bit more user friendly – right now they get the error message: Word could not merge the main document with the data source because the data records were empty or no data records matched your query options” but that can wait for another day.

Thanks for the help Hans, you’re a hero.

Oh so close…

When I hit the command button to initiate the merge, I get a pop up box stating “enter parameter value” – Document Name

If I enter the DocumentID in the box and hit OK, it picks the correct approval document, and I never get the pop up box again when I try to print subsequent approval documents until I stop and restart Access

If I don’t enter the DocumentID in the box and hit OK, it still picks the correct approval document, and I never get the pop up box again when I try to print subsequent approval documents until I stop and restart Access

If I hit “Cancel” I get the message: Run Time Error ‘3075’ Syntax Error (missing operator) in query expression ‘DocumentID = ‘, and debug points me to “strPathtoYourDocument = “C:Approvals” & DLookup(“DocumentName”, “tblDocuments”, “DocumentID = ” & Me.[Vendor Combo Box].Column(1))” in the code

I would not of thought of going that route. Makes perfect sense. I’ll give it a whirl and let you know how things go.

Thanks again!

Vendor Combo Box info:

Column Count – 1
Row Source – Vendors

And if I understand where you are going with this correctly, the relevant field in the vendor table is:

Field Name – Vendor Name, Data Type – Text

Or do you need all the field names in the vendor table? (there are quite a few).

I really appreciate the help. Thanks so much!

Thanks for the directions. I’m going to have to back burner this for the time being, but once I free up some time, I’ll give it a go.

Thanks for the directions. I’m going to have to back burner this for the time being, but once I free up some time, I’ll give it a go.

It was meant rhetorically, but now you have my curiosity going…

How would I use this if I merely wanted to pull the values out of an existing query and merge them into a word template?

It was meant rhetorically, but now you have my curiosity going…

How would I use this if I merely wanted to pull the values out of an existing query and merge them into a word template?

Will do. Thanks for the links.

Will do. Thanks for the links.

This looks great but it is bit beyond my current capabilities, so naturally I have some questions like:

What does this line do? mypath = CurrentProject.Path & “templates”
This would be the name of my template? Strletter = “newChangeOfAddress.dot”

I could go on, but I really need to develop a better understanding of VB before I could discuss this intelligently. I do appreciate you sharing it, since it gives me some ideas.

This looks great but it is bit beyond my current capabilities, so naturally I have some questions like:

What does this line do? mypath = CurrentProject.Path & “templates”
This would be the name of my template? Strletter = “newChangeOfAddress.dot”

I could go on, but I really need to develop a better understanding of VB before I could discuss this intelligently. I do appreciate you sharing it, since it gives me some ideas.