Make-Table query command button

solty89

Registered User.
Local time
Today, 06:35
Joined
May 20, 2013
Messages
32
Hi guys,
i have a problem and i can't find a solution so far.So, i have a form, where im giving a criteria for a query through combo-box.I want a button that will save the results from the query in a new table, after i choose the value in the combo box.I know that cloud happend with make-table query, and i think that cloud happend automaticly with VBA module, but i don't know anythink about VBA.I know just how to open the module window (alt+f11) and thats it.Can anybody help me pls?

ps. sry for my bad english
 
You can use the command "Currentdb.Execute" to run any create table statement...
research that command and see how far you get, if you get stuck post back here :)
 
You can use the command "Currentdb.Execute" to run any create table statement...
research that command and see how far you get, if you get stuck post back here :)

Thanks Namliam,
i understood what the function is doing, but i don't really know how to build the code, so can u help me with an example, so i can get it.
 
Your average create table query you can create using a the query building, it should look something like:
SELECT Column1, Column2, column3
INTO tblYourToBeCreatedTable
FROM tblYourExistingTable
Where Something = another;
 

Users who are viewing this thread

Back
Top Bottom