Re: Can I get a form to automatically select next available number

Tech-Archive recommends: Fix windows errors by optimizing your registry

It's due to the paper filing system. All students have a numbered file and
once it is moved to the archive filing cabinet the student file gets a
different number. Therefore the files in the 'current students' cabinet get
reused. There are two identifying numbers, student id (college issued) and
student number(for our filing system). The Student ID is a unique identifier
but the student number can be the same (one current and one archive!) It
makes sense for paper but once you start digitising it makes it a bit
complicated which is why i'm after your help.

"Jeff Boyce" wrote:

> Lisa
>
> Why? As in "why do you feel it necessary to 'use' every number?
>
> And let me point out that if you've "removed" record #70 to archiving and
> re-use #70 and ever need to dig out archived information, you have to
> resolve which #70 you are referring to!
>
> If you have a need to make records less visible/accessible/whatever and have
> been moving them to another table to archive them, there's a much simpler
> solution. Add a field (a checkbox for yes/no, a datetime to document) to
> the table, and use it to indicate "archived". Modify your queries to show
> non-archived records.
>
> --
> Good luck
>
> Jeff Boyce
> <Access MVP>
>
> "Lisa" <Her@xxxxxxxxxxx> wrote in message
> news:E67F7BB0-A58D-4469-BD8E-D3300660EBDD@xxxxxxxxxxxxxxxx
> > I have a table with student records in access with some records removed
> for
> > archiving. e.g.
> > Student No 1stNm Snm City Course
> > 241, Joe, Bloggs, London, HNC Blah
> > 70
> > 81, Eve, Smith, Bristol, HND Blah
> > 23, Adam, Jones, Cardiff, HNC Blah
> > 150
> >
> > I have created a form connected to this table to allow input of new pupils
> > but I'd like it to be really clever and realise that records 70 and 150
> have
> > nothing allocated to them and are availble for use. Therefore when I open
> > form "New Pupil", in the student number field it would automatically say
> 70.
> >
> > Is this possible or am I being too adventurous
> > Thanks in advance
>
>
.

Relevant Pages