| View previous topic :: View next topic |
| Author |
Message |
Retarded_Noob
Newbie
Joined: 20 Jul 2005
Posts: 1
|
 Posted: Jul 20th, 2005 12:23 AM Post subject: Maybe you could help me with this |
 |
|
hi guys i am a beginner
i wish someof you may help me with this.....
thanks
------------------------
we all know that how AutoNumber and AutoIncrement works in Access and MySql
It automatically gives a value to the new added record
my question is..
how do we do that without using the AutoNumber in Microsoft Access
to be more specific..
====================
my table name = Products
the index field = RecordID(set as number istead of autonumber)
recordset name = Rs
textbox = txtRecID
=================
when i click button cmdNew
i want the txtRecID to be (the last records'record id)+1
so..how is the code going to be
_________________
Sorry for my stupidity if it bothers you  |
|
| Back to top |
|
blackhd
Newbie
Joined: 23 Jul 2005
Posts: 5
|
| Posted: Jul 23rd, 2005 01:11 PM Post subject: |
|
|
| use max(recid) |
|
| Back to top |
|
|
