Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2007

Tip: Looking for answers? Try searching our database.

numbering system in Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
senrabbit - 30 May 2007 08:50 GMT
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 - 30 May 2007 12:20 GMT
> 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

BruceM - 30 May 2007 13:18 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.