B
balu
dear friends,
kindly advise with the following
i want to have an query like this with vb
private sub button click()
docmd.runsql(select queryname.* into tablename from queryname where
queryname.field = fieldvalues;")
here queryname is an selectquery
tablename an new make table name
fieldvalues = recordsets of an table
i want have the query to run with all criteria fieldvalues in the table
for which kindly advise me how to use
FOREACH element IN table
NEXT element
and store all values in the new maketable
kindly advise with the following
i want to have an query like this with vb
private sub button click()
docmd.runsql(select queryname.* into tablename from queryname where
queryname.field = fieldvalues;")
here queryname is an selectquery
tablename an new make table name
fieldvalues = recordsets of an table
i want have the query to run with all criteria fieldvalues in the table
for which kindly advise me how to use
FOREACH element IN table
NEXT element
and store all values in the new maketable