Question on make table query 1

[tnguyen315]

Hello, please help with make table query.

I have 1 main table and 3 other tables linked with UserID on one – to – many.

I tried to make table query on 4 different tables within a certain time frame based on the date ([DateUsed]) on the main table. (My parameter in criteria in each query would be the same and like this “Between [Enter Begin Date] and [Enter End Date]”

I have no problem when run make table query on each single query. However, I would like to know is it possible to run all 4 queries at the same time and only enter the parameter only one time, instead of 4 times?
Thanks

 

[PWise]

create A for with 2 text boxes and a command button

text boxes
BeginDate And EndDate

Set the parameters in all 4 queries as
between form!formname!BeginDate And form!formname!EndDate

and in the on click of the command button

with docmd
 .openquery "query1"
 .openquery "query2"
 .openquery "query3"
 .openquery "query4"

end with

 

[tnguyen315]

Thanks pwise
It works like charm...Again, thanks alots

 

[tnguyen315]

Now I have a question similar to this one, but it’s gona be backward.

I have 2 databases named “A.mdb” and “B.mdb”

The database “A.mdb” is a blank database and only has one form named “frmMakeTable” with 2 text boxes named “BeginDate” and “EndDate” and a button named “cmdRunMakeTableQuery”.

The database “B.mdb” is SQL backend and access font end has ODBC instatlled on PC named “Food”.
Now I would like to make table queries into database A from those queries from database B based on the “BeginDate” and “EndDate” on the form from database A

Please help, I’m very appreciated. Thanks.

 

[PWise]

The make table quries are in a.mdb or b.mdb?

also what is the full path of both databases?

 

[tnguyen315]

The make table queries are in A.
A: K:\Custom\ENV\Food\A.mdb
B: K:\Custom\ENV\Food-HDH\ACB\B.mdb

Thanks

 

[PWise]

change make table quries Sql to

SELECT * INTO [I]NewAccessTableName[/i]
FROM [I]SqlTableNsme[/I] IN '' [ODBC;DRIVER=SQL Server;SERVER=[I]ServerThatSqlIsInstalledOn][/I];

 

[tnguyen315]

Could you please be more specific? I still don't get it.
Thanks

 

[tnguyen315]

I tried everything but no luck, if anyone knows please help. I'm very appreciated. Thanks.

 

[PWise]

what is the Sql of ypur quries

 

[tnguyen315]

sSQL = "SELECT * INTO myLocalTable FROM mySQLtable IN '' [ODBC;DRIVER=SQL Server;SERVER=PH-SQL]"
or
sSQL = "SELECT * INTO myLocalTable FROM mySQLtable IN '' [ODBC;DRIVER=SQL Server;SERVER=PH-SQL;]"
or either
sSQL = "SELECT * INTO myLocalTable FROM [ODBC;DRIVER=SQL Server;SERVER=PH-SQL].[mySQLtable]"

I even tried this
sSQL = "SELECT * INTO myLocalTable FROM [ODBC;Driver={SQL Server};SERVER=PH-SQL;DATABASE=Food].[mySQLTable];