Do you absolutely have to create new tables? Could you not just use queries
in place of these filtered tables, or even a parameter query that asks you
for a letter and a number when you open it?
for example:
Select * from myTable where field1= [enter letter] and field2=[enter number]
"access-newb" <sm****@frink.nuigalway.ie> wrote in message
news:11**********************@r2g2000cwb.googlegro ups.com...
Just started working in Access, and while I'm fairly confident in the
basics, or so I think, anything advanced doesn't work too well. I've
got a task I know should be easy to automate, but I don't know how to.
If someone could point me in the right direction it would be wonderful.
I've got 35 tables to create by running a query that filters a table
based on two criteria, and then names them based on the criteria used.
I have a table of the different combinations.
ie.
A 1
A 2
A 3
B 1
B 2
B 3
B 4
C 2
C 3
C 4
... .and so on to the 35 diff combinations.
Each table would be named "A 1", "A 2", etc, and all the other data
appears, but the two filtered criteria dont.
This is ridiculously tedious, and while I'm happy in VBA in Excel, I've
never touched it in Access, is there any "easy" way of automating this?
(preferably without VBA, but if there isn't a way to do it wihtout VBA,
then please do post it).