Excel VBA SQL from Access no results

Using Excel 2010 to query an Access 2010 Database (via UserForms). When I execute the code, I get my Message Box “No Results” (called near the end of the sub). However, there should be 12 records …

VBA Query based on multiple “multiple select list boxes” in Access when not selecting an item from one of the multiple select boxes

I have the following vba that creates a query in a test Access database. I have two multiple select list boxes. The issue is, i want to be able to select multiple items from “Me![State]” and none …

Rip 20 million rows from Power Pivot (“Item.data”)

I received a workbook which contains two tables in power-pivot (one around one million rows, another 20 mill rows). I would like to rip this out (as anything really – but let’s say a CSV) so that I …

SQL query search by ID and get another attribute of the record

I’m working on a DB where I need to search MAX(ID), where ID is an autonumber, (basically the most recent record/last record) and then when found I want to get the receipt number. e.g. receipt table …

What is the best SQL statement to query a table using Excel 2010 VBA with ADO (or vb.net with LINQ)

Table Name: employees Right now I am stuck on trying to figure out how to combine two of my SQL queries into one. Query #1: SELECT * FROM `employees` WHERE `name` = ‘BOB’ …