Change SQL query values in connected database

[stacyg]

I have a connected database that I want to be able to create a selection box on, which once filled out I can click on a button and update my connected SQL Query. This is the query and it is fairly simple. I want to be able to change the item in the where statement. Anyone ever do this? I have found online where someone did something like this but I really did not understand the process described.

select ITM.Item, ITM.Descr as 'Description', ITM.PurchPrice as 'Purchase Price', ITM.EAI, ITM.OrdQtyEOQ as 'EOQ', ITM.Buyer, IW.[QtyOnHand] as 'Quantity on Hand', ITM.InvOnOrder as 'On Order', IW.[WH] as 'Warehouse'


From SpectraData.dbo.Items as ITM
left outer join SpectraData.[live].[RV_InvItemWH] as IW on
ITM.Item = IW.Item

where ITM.item = '90947689'

Thanks everyone!

 

[bfreescott]

This is an Excel forum, so I assume you are trying to query a database from VBA. Are you using DAO or ADO? Can you post the whole procedure?

 

[stacyg]

Sorry man, DAO or ADO mean nothing to me sorry.

I created an SQL query like the one above. I then connect a SQL database to excel through "From Other Datasources", then I go to connections and change the report from a "table" to "SQL" and paste it in to the properties and I get the result of the query in excel. What I want to do is change the "item" as mentioned above through a cell entry with new item and then have a button to trigger. I am just starting to learn VBA. I am an advanced excel user but have only recently really needed to use code to automate and add advanced function. I am sure I need to run the query from VBA but I don't know how yet.

Thanks in advance for helping me out.