Software

Ask something
Discussion Locked

Creating a label program in Access

0 helpful
1 reply

by vpierce

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

1 reply

by haileyan

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!

This discussion is closed to new replies.