creating queries in vba and batch help

[Ashank4vba]

Hello,

Is there a way to create and save a query in an Access database using vba?

Also, which is the best way to automatically run a function from access every evening around 7 PM? Form timer?

Thanks a lot for your help.

-cheers
Arvind

 

[MajP]

For the scheduling Read the FAQs there are many examples. Here is one
FAQ181-1378

For your first question look at the "querydef" object.