using VBA how can i copy a record from a query and then paste it .

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

Guest

using VBA how can i copy a record from a query and then paste it into a table
as a new record
 
Madguru,

I think this would be a job for an Append Query, which can be run from
code in several ways, one being to use the DoCmd.OpenQuery method.
 
You must log in or register to reply here.

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: How can I use a string variable as autofilter criteria? 4
vba powerpoint pasting named shape in selected named slides 0
How to export table from outlook into ms access table? 0
Macro to copy value in field and insert it into filter 2
Webcast recording. 3
using excel vba ope a word doc and copy-paste into another word doc 0
Suppress records based on VBA logic 3
Access Access Record Order 0

Back
Top