sql filtering

  1. M

    How to assign query statement to combobox item?

    I have a separate method for database query. But I dont know how to connect it with combobox items? Whereas, if I select Combobox1 item1 it will direct to query and on button click will execute query. I tried putting it in Select Case, but not working. Thank you!
  2. R

    Optimizing production reports - MS Query

    Hi I have several big excel reports that pulls data from a db via MS query. (100 000+ rows in each) I use countifs formulas to show production volume based on parameters within the data. This seems like an unefficient way to do this. First of all it takes a long time for excel to process it...
  3. L

    Excel 2013 VBA to Outlook 2013 Paste clipboard to SQL Dasl filter in specific folder

    Hello all, I have created an Excel spreadsheet that works like this: a user clicks a .VBS file which opens my Excel spreadsheet (which stays invisible) and runs a specific macro a calendar pops up and the user clicks on a date A particular column within the spreadsheets resets to default SQL...
  4. M

    Over-Controling How Data Imports In Excel

    I have a query that pulls data from my database. The basic query looks like this: SELECT ClosedDate, ServiceRequestID FROM MyDatabaseNameHere Now SQL runs this and all my dates are in the basic format. (YYYY-MM-DD MM:SS:nnn) :( Since this is not user friendly I modify my query with Convert...
  5. T

    Getting Values out of a recordset

    Hi, I need to get values out of a recordset in order to filter a second sqlstring I constructed a filter query and get the records out of it in the first SQLstring in order to use the values to filter the second SQLstring. Unfortunately, when I set CountryCurveSelect =...

This Week's Hot Topics

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
Top