Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-08-2018, 08:36 AM
ArviLaanemets ArviLaanemets is offline User Control Windows 8 User Control Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Obviously you get data from SQL Server with ODBC query. Let's assume the query is something like


Code:
SELECT * FROM SqlView
You can have instead a query
Code:
SELECT * FROM SqlView WHERE Field1 = ? AND Field2 = ?
When trying to run the query it will ask for 1st parameter, and then for 2nd parameter. You can point cells in Excel worksheet as sources for those parameters, and set the query to be executed whenever those cells will change.

On sheet where queried data appear, leave/insert some empty rows at top (at least the number of parameters +1). Define Data validations to select parameter values at top cells, and select some parameter values there. Now redefine your query like was shown before, and point cells with selected parameters when asked.
Reply With Quote
Reply

Tags
excl, list, user control



Similar Threads
Thread Thread Starter Forum Replies Last Post
Could you help me create a control button/check box to enable user to delete a row? baes10 Word Tables 2 12-11-2017 10:10 AM
User Control The USER ACCOUNT CONTROL window does not appear when opening an EXCEL file NathanEat Word 4 05-27-2015 09:04 PM
How can I get Outlook from one user to another w/o a .pst file (primary user on computer is corrupt) Tenmakk Outlook 0 03-01-2015 12:49 PM
User Control Rich Text Content Control - Allow User Formatting keithacochrane Word 1 05-28-2012 05:06 PM
issue in nested user control selva Misc 1 10-20-2011 10:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:09 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft