eof plus 1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a temp table which data is entered into from a form. Once all the
details have been keyed and a cmd button is clicked the data from the temp
table is copied into the main table with additional data.

the problem I have is how to make sure that the very last record is also
added to the main table as at the moment with my Do ...Loop Until rs.eof the
very last record is not copied over.

I need to somehow tell the program to do the last record also without having
to duplicate my code for copying the data over.

Thanks
Noemi
 
Hi
Dont worry about this I worked out that I need to do the Until rs.EOF at the
beginning ie do until rs.eof.

Thanks
Noemi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
VBA - retrieve data on last create named range from previous inserted named range 0
Copy data from one databse tabel to other database table 1
Allen Brown's audit log code "insert" problem 0
Record-Locking remains open after closing 0
Check table for like values 4
Parent Set Focus problem and subform table update 2
Yes - I want duplicate records 3

Back
Top