Add Next Number To A Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ange Kappas - 08 Feb 2008 17:31 GMT

Hi,
This is probably so simple I can't seem to figure it out.

I have a Table(tblACCOUNTNO) which has only one field called ACCOUNT NUMBER
and starts from number 1.

I want to add code to a form button which will add a new record to the
'tblACCOUNTNO' and it will be the next number in other words +1, which in
this case will be number 2.

How simple does that sound.

Thanks
Ange

Reply to this Message

fredg - 08 Feb 2008 18:26 GMT

> Hi,
> This is probably so simple I can't seem to figure it out.
[quoted text clipped - 10 lines]
> Thanks
> Ange

Dim strSQL As String

strSQL = "Insert into tblAccoutino([Account Number]) values (" &
DMax("[Account Number]", "tblAccountino") + 1 & ");"

CurrentDb.Execute strSQL, dbFailOnError

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Ange Kappas - 09 Feb 2008 08:19 GMT

Thanks Fred Appreciated
Ange

>> Hi,
>> This is probably so simple I can't seem to figure it out.
[quoted text clipped - 18 lines]
>
> CurrentDb.Execute strSQL, dbFailOnError

Reply to this Message