General discussion

Locked

Creating a label program in Access

By vpierce ·
I need to create a label program in Access where the user enters a prefix for a group of labels, then enters the number of labels the he/she wants to print and the output would look like this

REEL #
RM2-999

Each label would include "REEL #" as a title and the prefix RM2 would change per deparment. Each label would have a different sequential number on it such 990, 991, 992, 993 based on the number of the labels the user entered to be printed.

Can Access does this?

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by haileyan In reply to Creating a label program ...

I have the great tool for you. It is a template for Microsoft Word not Access. The template was originally designed for creating bates labels for legal documents.

The template is for Avery 5267 which is the label with 80 labels per sheet. I hope those will work for you.

Anyway here is a link to the download page:
http://www.payneconsulting.com/public/products/ProductDetail.asp?nProductID=10

It is a free tool. The company providing the template can make modifications in case you need it for different label size.

With this template you would basically enter:
LINE1: REEL#
LINE2: RM2-##

The ## is a place holder for the numbering you specify on the right.

Hope this helps!

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums