Generating Numbers

[mwsmith]

I have imported an excile file into a new table. I chose my own primary key,
which was the field that had Patron ID numbers. There are no duplicate
numbers. When I create a new Patron, I want Access to generate the Next
Patron ID number in sequence to the last ID number? I have Access 2000. Can
anyone help me. I've looked at similar questions and answers, but they do
not help.

 

[PC Datasheet]

Me!NextPatronID = DMax("PatronID","NameOfYourTable") + 1

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


"(e-mail address removed)"

 

[Jamie Collins]

I have imported an excile file into a new table. I chose my own primary key,
which was the field that had Patron ID numbers. There are no duplicate
numbers. When I create a new Patron, I want Access to generate the Next
Patron ID number in sequence to the last ID number? I have Access 2000. Can
anyone help me. I've looked at similar questions and answers, but they do
not help.

Have you looked at this one?

How To Implement Multiuser Custom Counters in Jet 4.0 and ADO 2.1
http://support.microsoft.com/default.aspx?scid=kb;en-us;240317

Jamie.

--