Pass combo box selection to docmd.runsql

[xopherira]

How do you use a combobox selection as a variable for runSql? I would like to be able to make a selection and have the field chosen from comboBox be the input for "comboBox_selection" in sql command.

DoCmd.RunSQL ("ALTER TABLE comboBox_selection " & "ADD keyColumn COUNTER;")

[orange]

You would normally design your tables and fields based on your business requirements. One would not expect to have to add fields to table via a form (especially an autonumber field) during operations.

Tell us more about your business requirement.

[ranman256]

you wouldnt. normally youd put the parameters in a query and run the query via docmd.openquery myquery

[orange]

You wouldn't (perhaps 1 time in 10000) be using an Alter statement to modify a table design to add an autonumber field into an operational database.

You might use a development database and test something, but this is NOT A NORMAL PROCEDURE. In test or development you would create the table with a utility or manually.

[xopherira]

The problem is i am loading an excel template. I need to add a key field to template and delete before the export. This all needs to be done behind the scene without interaction from user in terms of the user not modifying the excel spreadsheet.

[orange]

Why? Wouldn't the key be useful to the user or his/her queries etc?

????

I need to add a key field to template and delete before the export.

My gut feeling is you have not made a commitment to leave Excel, or use Access(database) as was intended.
But you know What you're trying to accomplish better than readers do.

[xopherira]

The reason has to do with the fact I am working with leagcy process between a cutomer facing team and production team. Neither of these would need or use queries. They are going to run a tool that processes an excel spreadsheet.

[orange]

Perhaps you could tell us more about the requirements and give us some context, and perhaps some sample data.
How do you expect readers to get some "feel" of your application or need from
"How do you use a combobox selection as a variable for runSql?"

Why can't you build the tool based on your requirements? Are you trying to tell readers that your needs change with every run?

[ItsMe]

Maybe something like the following is what you are asking for.

Dim strSQL As String
strSQL = "ALTER TABLE " & Me.ComboBoxName.Value & " ADD keyColumn COUNTER;"

CurrentDb.Execute strSQL, dbFailOnError