Hello,
I have table name
master and there is field
itemcod i want whenever I pressed
add buttton in form
it generate max number from table
and display in textbox
Is it possible with sql query
I am using Ado vb6 access 2000 table
Bye
Printable View
Hello,
I have table name
master and there is field
itemcod i want whenever I pressed
add buttton in form
it generate max number from table
and display in textbox
Is it possible with sql query
I am using Ado vb6 access 2000 table
Bye
sql = "select max(itemcod) as maxid from master"
rs.open sql,connection
text1.text = (rs!maxid) + 1
Did you get an idea?
[Edited by sanon on 09-02-2000 at 03:19 AM]