> Hi
> I am new to this forum so be gentle with me!
[quoted text clipped - 9 lines]
> Hope
> this makes sense.
The article at the following URL describes AutoNumber fields.
http://office.microsoft.com/en-gb/access/HA010550671033.aspx?pid=CH010717771033

Signature
Brendan Reynolds
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%20Your%20Sur
vey%202000'
> Hi
> I am new to this forum so be gentle with me!
[quoted text clipped - 9 lines]
> Hope
> this makes sense.