parameter

Hello, I'm struggling for a while with a generic mechanism to assign some short-cuts to methods that are implemented in classes. This is what I have so far: In a class module ("test2"): Private Sub Class_Initialize() Dim var(0 To 1) As Variant var(0) = 5 var(1) = "ThisIsAstring"...

Hi, I have a problem with a query with parameters in MS Excel. I have a database in MS Access where I set up some queries. I want to be able to transfert a result of a query to MS Excel to a pivottable. I did it by getting external data (ms query). I wanted my query to get parameters from a...

I have a table with several fans. Each fan has one of a few different types (ex. axial, centrifigual, etc). Another table contains the geometry of the fan (ex. diameter, blade details, etc). I want to create a form to allow the user to input this geometric information for each fan. However, I...

Please help, or I'm going to have a bald spot (bad for girls)! The following query works fine if I substitute actual dates for the parameters, but if I try to enter dates into fields on the spreadsheet and reference those fields in the query instead, the query completely ignores the dates and...

Hi eveyone, My question seems to be unique, so far I have failed to find a solution. I call a function from an Excel sheet which gets live data from a stock server. My Function parameters are bid, ask, number of shares sold, number of shares bought, and several other relevant data. The...

I'm new to Access and need some help with some data manipulation. I have a database that tracks 8,000 unique individuals' participation in a series of 35 events. Not all individuals will participate in these events. There is one table that holds all of the data. Each of the 35 events has a...

While running a report (one which has several groups, and several subreports) I get one parameter I expect ("Enter ID number you wish to report on") as well as a parameter I did not expect to see. It just says "Catalogue". Which is the name of a table which the main report is based on and the...

I want to use the Connection functionality in Excel 2010 to connect to a SQLSERVER 2008 database and populate column X based upon using a value in Excel column A as the primary key (loop thru the column), but unable to find out how. I have tried (typing in the command text window) select...

I am using query parameters to pull in information. It is looking at a cell for the value to use, but my question is what do you enter in that cell if you want it to pull everything?? Basically if there is an instance where i dont want to use that criteria for a search? Thanks

Hello, So, it's been a month since I started VBA excel and I am trying to merge 2 worksheets into an already created new worksheet in the same workbook. Worksheet 1 has 51 columns/parameters Worksheet 2 has 53 columns/parameters They have 42 columns/parameters in common. First row shows the...

Hi there, I built a custom function in vba. When called from a cell in excel, I want the parameters to pop up to assist the user as they would for a built-in excel function. Is there a way to do this? Example of kind of function I'm talking about: function test (hello as Integer) As...

Has anyone else had the problem I am having with a parameter query in Excel 2007? I set up a query in MS Query to an external database with the parameters being a start and end date. The results of the query are returned to a PivotTable in Excel. By editing the connection properties, I can...

I have created a Parameter Query Form with 3 drop down criteria fields (1-Product, 2-Failure Mode, 3-Failure Mechanism). The 'row source' for the drop down fields are from another query. The issue I am having is that sometimes one or two of the drop down fields will be left blank. If any of...

Hello all, I'm having an issue with a data connection in Excel 2007. I've not been able to find a solution anywhere online so I'd be tres grateful if anyone could shed some light on this. SQL Server is involved but I believe the problem is with Excel so apologies if people think I'm posting...

Dear all, Please forgive me if i ask too easy question, but i need some help. thx. I m trying to create a pivot query chart based on parameters i enter in excel. as shown in attached screenshot of my pivot chart, i have successfully added parameters and linked them with pivot. So when i...

Cells.Replace What:=UserForm1.TextBox1.Text, _ Replacement:=UserForm1.TextBox2.Text, LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False If I am typing in the above line as part of a VBA Macro in the IDE, intellisense helps me a lot. As soon as I type in "Cells." it shows me all...

Hello, I have been searching (a lot!) to find a solution to being able to prompt for parameters for a SQL Pass Through query from Access to SQL Server. I found examples using stored procedures on the server but I do not have write access to the server in this case. I don't have create procedure...