
02-03-2002, 11:21 AM
|
 |
Code Factory
Retired Moderator * Expert *
|
|
Join Date: Jan 2001
Location: Montreal, Ca.
Posts: 5,565
|
|
|
OOPs, forgot to answer Q1.....
I never used Dlookup, but maybe you can take the logic from an INSERT INTO.....
"SELECT Field1, Field2 INTO OtherTable1 IN 'c:\OtherDatabase.mdb' FROM ThisTable1 WHERE Field2= '" & strText & "'"
|
|