# Re: about defin field

Posted by jen on October 04, 1998 at 23:29:24:

In Reply to: Re: about defin field posted by AndyLin on October 03, 1998 at 09:33:18:

:
: 假设你是透过 DAO 之方式存取 Database 试试以下作法
: dim rst as recordset
: dim AutoNum as integer
: set rst=database.openrecordset("select numfield from numtable where 过滤条件")
: if rst,eof then
: autonum=1
: else
: autonum=rst("numfield")+1
: end if

: 如此即可取得流水号之值,再自行将其转换成你所要之字串
: :
: :
: : Thanks for you'r kind !!!!!
: :

Follow Ups: