insert query

  1. bs0d

    ADO Insert Query with Parameter(s)

    I've built an ADO function in VBA to handle queries to an Access database. It's setup to process queries with 0 - 2 parameters. I'm trying to expand it to handle an Insert as well. When the Insert SQL and parameter are passed to the function, Excel locks up. Where am I going wrong with...
  2. bs0d

    ADO Insert Query

    I've managed to query my MS Access database through Excel using the ADO method. I'd like to learn how the syntax differs for an INSERT query; specifically when inserting values from a form. Here is the code I use for a SELECT query: Set myConnection = New ADODB.Connection Set myResults = New...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top