Manually increment ID in a table 1

[postmanphat]

Hi,

I've had a quick look on here and online but without a great deal of luck.

I have a table that has 2 fields AutoID (autonumber) and AppID (number).

I want the AppID field in a new record to increment by 1 from the previous AppID when a new record is added.

On the form, I already have a button that the user hits to enter the date onto a new record, so any actions can be assigned to that button if that makes life a little easier?

All help is, as ever, most appreciated.

Thanks in advance.

Dave

 

[Remou]

If you have more than one user, MichaelRed's FAQ should be of interest:

http://www.tek-tips.com/faqs.cfm?fid=184

http://lessthandot.com

 

[postmanphat]

Nope, its just a single user system.

 

[Remou]

In that case, use DMax to get the maximum previous value and add one.

http://lessthandot.com

 

[postmanphat]

Thanks Remou, I've had a look on google and found websites such as this

http://www.599cd.com/tips/access/incrementing-your-own-counter/

that explain how to set it up. I've followed these steps and similar things from 4 or 5 other websites but can't seem to get it to work at all.

Every single one I try appears to make no difference to the App field in my table but doesn't throw up any VB errors either?

A simple guide to DMax syntax would be really handy.... ;-)

 

[Remou]

There are quite a few examples on this site. What have you tried?

http://lessthandot.com

 

[postmanphat]

I've just found this

http://www.tek-tips.com/viewthread.cfm?qid=1494834&page=7

and its helped greatly.

Thanks