Create serial numbers that print only one time on Avery Form

[DennisC]

I want to create unique serial numbers to identify each computer in my
organization. I will assign the number to the computer the next time I work
on it by sticking a label with the serial number onto the side (or bottom if
a laptop) of the computer. A unique number assigned to each computer makes
asset tracking, billing, etc. easier to to manage.

The serial number I want use is C-00001 thru C-99999. That should cover
existing, new, and replacement computers for far longer than I need.

I want to be able to print them on small labels, like Avery Return Address
labels, one or two sheets at a time. And have the next print job start with
the next serial number, never reprinting any of the previous.

I'm a bit rusty with Access, OK, very rusty. I've done this type of thing
several years ago, but I'm now using Access in Office 2007.

I'm hoping there is a template that accomplishes this, but if I have to
write it myself I can with a little help. If the instructions or template are
in Access 2003, 2002, or 2000, that's OK too.

Thanks in advance.

 

[Lord Kelvan]

well for inserting the serial numbers you can make an auto number in a
table and then use an input mask "C-00000" for that

auto number though for all intensive purposes you shouldnt do that for
meaning fult information but it is the eaisest method there is
a more complex one using a form or even using a complex query but to
do that you would have to at least haev one record in the database at
all times.

for printing them off you can use a report and rather than having the
serial number ... thingy (considering i dont actually remember the
word for it but it is the label on the report that is bound to the
serial number in the table) on the page section rather than the
details section and that will basically put each one on a different
page then all you need to do is mess with page set up for it to appear
on what ever size paper you are using.

hope this helps

Regards
Kelvan

 

[Lord Kelvan]

sorry that was not input mask that was format for the serial number
appearance

 

[DennisC]

Yes. Auto number is the first part of creating the database, if we can call
it that. It's just a string of numbers. Thank you. I couldn't quite pull that
out of my head.

The next thing I need to do is, for example, print the first 80, or however
many labels on the sheet, and on the next print job a week or two later,
print the next 80 numbers. Is there a way to tell Access (in a Form or a
Query) to continue where I left off, not from the beginning again; to have
Access keep track of the last number printed?

 

[Lord Kelvan]

you would need to create a table or something which would store that
number then you can have a query that will read the serial numbers
from that point onwards

hope that helps

Regards
Kelvan

 

[Margaret Bartley]

I want to create unique serial numbers to identify each computer in my
organization. I will assign the number to the computer the next time I
work
on it by sticking a label with the serial number onto the side (or bottom
if
a laptop) of the computer. A unique number assigned to each computer makes
asset tracking, billing, etc. easier to to manage.

The serial number I want use is C-00001 thru C-99999. That should cover
existing, new, and replacement computers for far longer than I need.

I want to be able to print them on small labels, like Avery Return Address
labels, one or two sheets at a time. And have the next print job start
with
the next serial number, never reprinting any of the previous.

You will need a table to keep track of the last serial number used.

I quite frequently have an Options table in my databases that keeps track of
the last location of a datafile, the last file that someone looked up, the
last serial number used, etc. It has just one record.

DO NOT make the serial number Autonumber. It gets really confusing, and
it's not all that difficult to get the last serial number used, and
increment it by one.

The form that prints the labels can have an unbound text box that defaults
to
=dFirst("SerialNumber","Options")+1

That's your next serial number and it will appear when the form is opened.

According to your needs, you can have a command button that will reset the
number if you do other things on that form, and end up reprinting labels
with a new number, without reopening the form. You will also have to put
some logic in to update that serial number, after you know what the last
serial number was :
DoCmd.RunSQL "Update [Options] set SerialNumber = " & lSerialNumber &
";"

 

[DennisC]

This will help me get started. I'll work on this over the weekend, but any
more comments and suggestions will probably be helpful, too.

I like your suggestion to not use Autonumber, but in effect, make my own. I
know what you mean that Autonumber can get confusing, it can be
uncooperative, too.

I'll post my progress and, I'm sure, successful outcome.

I want to create unique serial numbers to identify each computer in my
organization. I will assign the number to the computer the next time I
work
on it by sticking a label with the serial number onto the side (or bottom
if
a laptop) of the computer. A unique number assigned to each computer makes
asset tracking, billing, etc. easier to to manage.

The serial number I want use is C-00001 thru C-99999. That should cover
existing, new, and replacement computers for far longer than I need.

I want to be able to print them on small labels, like Avery Return Address
labels, one or two sheets at a time. And have the next print job start
with
the next serial number, never reprinting any of the previous.

You will need a table to keep track of the last serial number used.

I quite frequently have an Options table in my databases that keeps track of
the last location of a datafile, the last file that someone looked up, the
last serial number used, etc. It has just one record.

DO NOT make the serial number Autonumber. It gets really confusing, and
it's not all that difficult to get the last serial number used, and
increment it by one.

The form that prints the labels can have an unbound text box that defaults
to
=dFirst("SerialNumber","Options")+1

That's your next serial number and it will appear when the form is opened.

According to your needs, you can have a command button that will reset the
number if you do other things on that form, and end up reprinting labels
with a new number, without reopening the form. You will also have to put
some logic in to update that serial number, after you know what the last
serial number was :
DoCmd.RunSQL "Update [Options] set SerialNumber = " & lSerialNumber &
";"