fake Autonumber
in [General]
|
Prev: Access Report
Next: Adding a field to a subquery
From: Tom van Stiphout on 18 May 2010 22:18 On Tue, 18 May 2010 08:53:01 -0700, Emma <Emma(a)discussions.microsoft.com> wrote: Oops I was mistaken and John was right. Use the expression builder and you will see what you can and cannot do. Populating this field in the associated form may be your best bet. -Tom. Microsoft Access MVP >Unfortunately it doesn't like dmax > >"Tom van Stiphout" wrote: > >> On Tue, 18 May 2010 07:08:03 -0700, Emma >> <Emma(a)discussions.microsoft.com> wrote: >> >> Try setting that as the Default Value for the field. >> >> -Tom. >> Microsoft Access MVP >> >> >> >Hi I already have an autonumber in my table and would like to have a second >> >one just for certain items. Can I use the following somewhere in the table's >> >definition: >> >dmax("FieldName", "TableName") + 1 >> . >>
From: David W. Fenton on 19 May 2010 16:45
Tom van Stiphout <tom7744.no.spam(a)cox.net> wrote in news:rii6v5tsupenftlj29ci1q5gvsgrv9mpqe(a)4ax.com: [in re: expressions as default values] > Oops I was mistaken and John was right. Use the expression builder > and you will see what you can and cannot do. But doesn't the A2010 table-level data macro change this? You can now have your custom Autonumber run at the engine level using one, right? Looks like a big win to me. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |