Script for Searching and copying tables

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

Guest

I'm new to programming for Access. What would a macro look like for searching
down a column in a table for a value, then copying the row containing that
value, and the next two rows after to another table?
Thanks
 
Realistically, that makes no sense.

You should never assume anything about the order of rows in a table. And to
copy from one table to another (which should rarely, if ever, be necessary)
is best done with an Append query, not code.

Perhaps you should explain what you need, not how you think you can achieve
it, and someone will be able to offer a suggestion.
 
I have a large list of account details that are in columns. They are sorted
by account:

Account1

info ...
info ...

Account2

....
....

I need to somehow extract all the info under a specific account and copy it
onto another file. (ie a spreadsheet).
 
Back
Top