Prev: Many tables
Next: Return Random Sampling from Query
From: Octet32 on 30 Mar 2010 09:25
I have a Make table Query when the Query is completed I am ask do I want to
Make table which I then need to click yes to make the table is there a way
I can create a Marcro or VB code that will automate this? The queries are
very large.
I am new to Access please can anyone help with this?

From: RonaldoOneNil on 30 Mar 2010 10:33
In Code

DoCmd.SetWarnings False
DoCmd.OpenQuery "Make Table 1"
DoCmd.OpenQuery "Make Table 2"
.
.
.
DoCmd.SetWarnings True

"Octet32" wrote:

> I have a Make table Query when the Query is completed I am ask do I want to
> Make table which I then need to click yes to make the table is there a way
> I can create a Marcro or VB code that will automate this? The queries are
> very large.
> I am new to Access please can anyone help with this?
>
 | 
Pages: 1
Prev: Many tables
Next: Return Random Sampling from Query