Script for Searching and copying tables

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
 
D

Douglas J. Steele

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.
 
G

Guest

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).
 

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

VBA - retrieve data on last create named range from previous inserted named range 0
Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Record (row) count by Table in Database 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
transferring data in rows of one table to columns of another table 1
Search a data (EmployeeName) from all the tables in the database m 7
Table to Array 1

Top