Can you run an append query with selection criteria from VBA

[richmond88]

Hi all,

I want to run an append query from VBA and attach a criteria.

A: Is this possible
B: If it is how do you do it.
C: If it isnt is there a workaround.

Thanks

Chris

 

[traingamer]

A) Yes

B) There are multiple ways including running an existing append query or just coding it in VBA. Search the Microsoft Access Modules forum for: append query

C) n/a

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[PHV]

Take a look at the DoCmd.runSQL method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244