numbering system in Access

[Guest]

Hi
I am new to this forum so be gentle with me!
Is it possible to create a numbering system within Access so that every time
you print off the same file it has its own unique number printed on the
document? along the lines of a raffle ticket system. I am trying to think of
a way of indentifying individual documents as they are returned to me. I
basically created a questionaire in Access and will be sending out over 200
of the same document but need to identify each reply on its own merits. Hope
this makes sense.

 

[Brendan Reynolds]

Hi
I am new to this forum so be gentle with me!
Is it possible to create a numbering system within Access so that every
time
you print off the same file it has its own unique number printed on the
document? along the lines of a raffle ticket system. I am trying to think
of
a way of indentifying individual documents as they are returned to me. I
basically created a questionaire in Access and will be sending out over
200
of the same document but need to identify each reply on its own merits.
Hope
this makes sense.

The article at the following URL describes AutoNumber fields.

http://office.microsoft.com/en-gb/access/HA010550671033.aspx?pid=CH010717771033

 

[BruceM]

The meaning of this is unclear to me:
"every time you print off the same file it has its own unique number printed
on the document"
I think you mean that if you print out 200 copies, you want each copy to
have its own number from 1 to 200. If you print out the same report a week
later, do you want the numbering to start from 201?
There is some code at the Word MVP site that can probably be adapted to your
needs (although it is a "Word Only" solution, I think; it does not involve
Access directly).
http://word.mvps.org/FAQs/MacrosVBA/NumberCopiesOf1Doc.htm
Using Access, it occurs to me you could create a table (tblSeqNum) that is a
list of sequential numbers. That is, it would contain one field: SeqNum or
something. If need be, you could base a parameter query on the table, with
the criteria for the SeqNum something like:
Between [Starting Number] And [Ending Number]
Use the table (or query) as the record source for a report (rptSeqNum). In
the Sorting and Grouping dialog for rptSeqNum, group by the SeqNum field.
Put a text box bound to SeqNum field into the group header or footer. Set
Force New Page to Before Section or After Section, depending on where you
have put the SeqNum text box.
From your description it sounds as if the questionaire is a form that is to
be printed and distributed as paper copies only. If so, build an unbound
report to serve as the questionaire. Add this as a subreport in rptSeqNum.
Each record in tblSeqNum consists only of a number. You are printing a new
page for each record, so you will have the sequentially numbered
questionaires. If you are printing a survey for everybody in an
organization, you could use the same approach, except you could use the
Personnel table instead of the SeqNum table for grouping.
It's not clear what you intend to do when you get the questionaires back.
Are you entering the results into a table, with each record identified by
the number you printed on the questionaire, or what exactly? The following
link may be of help in designing a survey:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'