hi
u just need to move the recordset that u assigned to the rowsource to the record u wnat
use rs.filter or rs!move()
ex
dim rs as recordset
rs.open(select * from order")
set cmborder.rowsource=rs
cmborder.listfield="OrderNo"
' to do what u want u can do this
rs.move(0,20)
this will...
if u want the L value aray to have the size of sum of the two args
ex
ar1=(2,2,1)
ar2=(1,4)
'expected otput ar3(2,2,1,1,4) if so do this
dim ar3() as integer ' dynamic array
dim lar1
dim lar2
....
lar1=ubound(ar1)
lar2=ubound(ar2)
redim ra3(lar1+lar2) as integer
'use a loop to copy the value
hi
do this
lets say the forms are
frmOrder and FrmFind
and the that callls the frmFind be FindOrder()
if u r expecting a return from the FrmFind u should Declare a public variable in frmOrder say
Public FindParam as string
now for the FindOrder() , use modal form
sub FindOrder()
...
you might not need to go as far as SQL server u can just use access, containing two tables related by the tag, whenever the csv is requierd u can export it using the adodb recordset object save(filename,scv) to scv format.
it is faster consistant and reliable than a text file
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.