Re: Auto Number

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

Dangerous.

First, if you are using a field that is an auto number, you have no control
over the number that is generated.
Second, do you plan to have more than 99 records per year? Your numbering
scheme appears to be limited to that.

I would split the field into two components. YearNumber and RecordCounter
and combine the two when needed to display.

Allen Browne has given you code to generate the number if you stick with
your current scheme.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"EbonLinctus" <EbonLinctus@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5386F49C-E901-4481-8504-5AFC2DC3DAEC@xxxxxxxxxxxxxxxx
I review every post regarding the above subject, but I am not sure any of
the
suggestions apply so I will post my issue.

I want my auto number column to format as follows: 200701, 200702,
200703... Seems easy, but the kicker is that next year, I want it to be
200801,200802,200803,...


.

Relevant Pages

  • Re: Civic SI replacement?
    ... well away from the sporty range in order to maximize mpg. ... either you're failing to articulate your original point or you're trying to wriggle out of the fact that there's no inherent output difference between a honda auto and a honda stick. ... the only difference is the control system. ...
    (rec.autos.makers.honda)
  • Re: Textbox autocomplete working only if multiline is set to false
    ... I used multiline with a custom control ... I think I'll move mack to one line control ... In my opinion, auto complete feature makes sense for one line of text, ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.windowsforms)
  • RE: Capture Table Name
    ... I thought this was a common enough report that some fairly direct way existed ... Your best bet would be sure all tables have an auto number field. ... each control on the form gets its data from. ... know how to capture username and date and time but I ...
    (microsoft.public.access.formscoding)
  • Re: Pondering Functionality
    ... Rather than remember a three-dimensional matrix of modes, and which user interface control does what in each mode, I want to simply set the desired value for each of the four parameters, via dedicated controls. ... fix shutter & aperture; auto ISO ...
    (rec.photo.digital.slr-systems)
  • Re: Ipod 4G belt case recommendations?
    ... Get an auto with an underpowered engine and they are horrid, ... still override the box down for some control and fun in the twisties. ... I've driven a Nissan Primera 2.0 with a CVT ... So thats the 924 with the old 2.0 engine chucked away and the later ...
    (uk.comp.sys.mac)