VBA, Copy Record from Table 1 to Table 2 - Acc97

Copy Record from Table 1 to Table 2 - Acc97 - VBA

Author	Message
johnwalker5 #1 / 2	Copy Record from Table 1 to Table 2 - Acc97 - VBA Am in need of some code that will let me do the following from my Access 97 application: Two tables are contained within application, Table 1 and Table 2. Read the first record of Table 1 and copy it to Table 2 and then close both tables. Thanks, John
Tue, 09 Jul 2002 03:00:00 GMT

Radu Lasca #2 / 2	Copy Record from Table 1 to Table 2 - Acc97 - VBA Look in help for the INSERT INTO sql statement. You'll need to use criteria to get the 'first' record, as 'first' is a clear concept only in an ordered set. Then look in help for the Execute method of a database object. If you have problems with the code, reply here, one may be able to assist you further. Hth -- Radu Lascae please reply to messages in the group Quote: > Am in need of some code that will let me do the following from my Access 97 > application: > Two tables are contained within application, Table 1 and Table 2. > Read the first record of Table 1 and copy it to Table 2 and then close both > tables. > Thanks, > John
Wed, 10 Jul 2002 03:00:00 GMT

Page 1 of 1

[ 2 post ]