Selecting Fields for a Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BruceF - 28 Dec 2007 00:43 GMT

I'm creating a "mail merge" type of report that will allow secretaries to
print labels. One example will print a student's name, their homeroom
teacher, and room number. Another example will print the parent's name,
address, city, state, and zip. I want the secretaries to pick the fields they
need for the labels. I have a form created with 4 lines with 3 combo boxes in
each (12 total). It's sort of like a "label template". Each value in the
combo box is from a table called PossibleFields that has the name of each
field available such as Last Name, First Name, Birthdate, GuardianName,
Homeroom Teacher, Room Number, etc. They can choose any field from any combo
box. The label will look like the fields chosen from the combo boxes.

Is this possible? Is there a better way?

Reply to this Message

KARL DEWEY - 28 Dec 2007 01:05 GMT

I suggest preplaning and create a template for them so they only pick which
template to use and then select names.

Have you tried from the other side - Word Mail-Merge? Open a blank Word
document, click on menu TOOLS - Letters and Mailings - Mail Merge. It opens
an additional window on the right and has step-by-step instructions and
choices. You can also backup in the process. Works fine for me.

Signature

KARL DEWEY
Build a little - Test a little

> I'm creating a "mail merge" type of report that will allow secretaries to
> print labels. One example will print a student's name, their homeroom
[quoted text clipped - 8 lines]
>
> Is this possible? Is there a better way?

Reply to this Message

Duane Hookom - 28 Dec 2007 04:18 GMT

The Query By Form at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane gives
users the ability to select fields and set criteria etc. The results are a
couple clicks from sending/exporting to a Word Merge file. This would allow
users to create any Word label template they want and then use the records in
Word.

Signature

Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

> I suggest preplaning and create a template for them so they only pick which
> template to use and then select names.
[quoted text clipped - 16 lines]
> >
> > Is this possible? Is there a better way?

Reply to this Message