Dynamically creating table using form

[Niros]

Hello,

I am trying to dynamically creating tables in Access 2010.
I would like to get the info from the user (Table name, number&type of columns)
and then creating the table using an SQL Query.

I know how to write the query, but I need help with passing the arguments to the query.

Please help me out, Thanks

 

[alsoascientist]

Hey Niros,

I just did a similar thing but with exporting the data... are you creating the query from VB? Does the user select from predefined fields?

I have some codes in my post 'Create Query from Where as recordsource' (I can't link the thread as I don't have enough posts but if you click on my name you should be able to find the other threads by me)
They will need a bit of adapting but I think they should work?