'如果text1与text2的头两个英文字母相同
dim str as string
dim lbd as integer,ubd as integer
str=left(trim(text1.text),2)
lbd=Cint(right(trim(text1.text),len(text1.text)-2))
ubd=Cint(right(trim(text2.text),len(text2.text)-2))
for i=lbd to ubd
insert into table(field) values(str & Cstr(i))
next i