make-table

O

Octet32

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?
 
R

RonaldoOneNil

In Code

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

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

Make-table query with around 2 ml records taking too long 0
Make table query: [Enter 1] AS Test 1
Access Dcount (multiple criteria) 3
dynamic calculated field in query 3
Make Table query, but remove character from field 5
link "make-table" queries and form for data entry 2
adding a field in a make table query 5
Run Make Table Query on Union Query 2

Top