Macros or Micros?

[jo-]

Aloha,
I am trying to output to a table, records, that have been selected in a macro, however, if I use CopyObject, or TransferDatabase, it will take the entire table. Is there a way using the Macro to copy the selected records? Thank you again for all your help..........jo-

 

[Rich]

Use an Append query

 

[jo-]

Rich, thank you for that, but the reason that I wanted to use a Macro, was because I need to pull 12 separate tables, and I wanted to do it all in one step or macro. Do you think there is a way in the macros?
Thank you.........jo-

 

[llkhoutx]

VBA code is substantially easier than using macros and much more intuitive. Try it, you'll like it.

 

[jo-]

Yes I'm sure you are right about using VBA, however I know nothing. Do you have any suggestions on a good starting book? I've looked at the code, but the only thing that I've been able to figure out, is that it is a bunch of sub-routines. Thank you for you help..........aloha!!!!!

 

[David R]

Starting off, if you're used to Macros, it can be helpful to convert all your old macros to code, then look at the results. See the similarities and differences between the two ways of doing things.

Also, as you type, Access VBA Editor is nice enough to prompt you (usually) for what you need to input next. For example, start typing DoCmd.OpenForm ,,,, in a VBA window.

Good luck,
David R