Ahhh yet another labels question

[Guest]

I have a many-to-many vendor database. I need to have Access to give me a
"prompt" that asks the user to type in a category. The query will then
access only those vendors that are in that category and list them in label
format in Microsoft Word. I don't want them in Access b/c they may need to
be wittled down even further for specific projects.
Please help.
Thanks.

 

[John Vinson]

I have a many-to-many vendor database. I need to have Access to give me a
"prompt" that asks the user to type in a category. The query will then
access only those vendors that are in that category and list them in label
format in Microsoft Word. I don't want them in Access b/c they may need to
be wittled down even further for specific projects.
Please help.
Thanks.

You'll have to be a bit clearer, Jessica.

You have a "many to many vendor database". Many... what to many what
else?

You have categories. Do you have a Table of categories? a table
relating vendors to categories, or what?

You say "list them in label format in Microsoft Word". Do you mean you
want to open Word and connect to the query in an Access database, or
open Access and have it create a Word document, or what?

You say "I don't want them in Access" - what "them" do you mean? the
vendors? the categories? or what?

John W. Vinson[MVP]

 

[BruceM]

John,

I participated in an earlier discussion on this topic, I think. If it is
the one I think it is, there is a vendor table, a category table, and a
junction table. The idea is that a form based on tblVendor is the main
form, and a form (continuous view, I think) based on tblJunction is a
subform. The subform (fsubJunction) has a combo box with tblCategory as its
row source. VendorID and CategoryID are the PKs of their respective tables,
and are FKs in tblJunction. I don't know what is up with Microsoft Word,
but I would guess the idea is to print labels for all vendors who are in a
particular category (e.g. all of the vendors for whom "Hardware" is a
category).
This is just by way of background. I cannot address the specific question,
but I hope I can help clear the way for you to offer a suggestion.

 

[John Vinson]

This is just by way of background. I cannot address the specific question,
but I hope I can help clear the way for you to offer a suggestion.

Thanks Bruce; that does help. I'll wait for Jessica to clarify the
Word issue.

John W. Vinson[MVP]

 

[Guest]

John - I do apologize for not being more specific or clearer. Bruce hit the
nail on the head (as always). I am trying to export this information into
Word by Category.
Thanks.
Jessica

 

[Guest]

I've figured out how to merge the data in an Access into a Word label merge.
I get all of the records. What I want to do is in Access have a button that
I click on that asks the user to either pick from a list of categories or
type in a category. This should generate a "short" query which will get
sucked into the Word labels document. As of now, I created a filter by form,
typed in the category and got the form to filter appropriately, but it still
brings all of the records into Word. Any ideas?
Thanks.

 

[John Vinson]

've figured out how to merge the data in an Access into a Word label merge.
I get all of the records. What I want to do is in Access have a button that
I click on that asks the user to either pick from a list of categories or
type in a category. This should generate a "short" query which will get
sucked into the Word labels document. As of now, I created a filter by form,
typed in the category and got the form to filter appropriately, but it still
brings all of the records into Word. Any ideas?
Thanks.

Create a Form - let's call it frmCrit - with a Combo Box (cboCategory)
listing all your categories.

Create a Query with a criterion on the category field

=[Forms]![frmCrit]![cboCategory]

Base your Mail Merge on this Query.

John W. Vinson[MVP]